SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001983s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.60' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.004320s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002163s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003339s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001357s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.60' ) [ RunTime:0.000762s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000873s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004091s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001060s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.006995s ]
UPDATE `stock_search` SET `count` = 2474 , `updatetime` = '2026-06-08 05:08:27' WHERE `partno` = '210' [ RunTime:0.002577s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000225s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000202s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001304s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.000311s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 5080,20 [ RunTime:0.050004s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('32749818','32746941','32741078','32740434','32731983','32728682','32723622','32715056','32698729','32696926','32680670','32677902','32676964','32670069','32669206','32662142','32659274','32659273','32651618','32651381') ORDER BY FIELD(s.id, 32749818,32746941,32741078,32740434,32731983,32728682,32723622,32715056,32698729,32696926,32680670,32677902,32676964,32670069,32669206,32662142,32659274,32659273,32651618,32651381) [ RunTime:0.003667s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32749818 LIMIT 4 [ RunTime:0.001003s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32749818 ORDER BY `minOrder` ASC [ RunTime:0.010037s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32749818 ORDER BY `unit` DESC [ RunTime:0.023017s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32749818 LIMIT 2 [ RunTime:0.010849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32749818 ORDER BY `minOrder` ASC [ RunTime:0.005861s ]
select * from pdf where partno='2106895' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011475s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106895' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32746941 LIMIT 4 [ RunTime:0.011605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32746941 ORDER BY `minOrder` ASC [ RunTime:0.009044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32746941 ORDER BY `unit` DESC [ RunTime:0.004843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32746941 LIMIT 2 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32746941 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='2106848' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106848' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32741078 LIMIT 4 [ RunTime:0.005260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32741078 ORDER BY `minOrder` ASC [ RunTime:0.007611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32741078 ORDER BY `unit` DESC [ RunTime:0.003023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32741078 LIMIT 2 [ RunTime:0.015215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32741078 ORDER BY `minOrder` ASC [ RunTime:0.014583s ]
select * from pdf where partno='2108917' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108917' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32740434 LIMIT 4 [ RunTime:0.012752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32740434 ORDER BY `minOrder` ASC [ RunTime:0.012359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32740434 ORDER BY `unit` DESC [ RunTime:0.029822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32740434 LIMIT 2 [ RunTime:0.008148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32740434 ORDER BY `minOrder` ASC [ RunTime:0.005076s ]
select * from pdf where partno='2101501' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101501' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32731983 LIMIT 4 [ RunTime:0.018217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32731983 ORDER BY `minOrder` ASC [ RunTime:0.017770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32731983 ORDER BY `unit` DESC [ RunTime:0.024683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32731983 LIMIT 2 [ RunTime:0.006462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32731983 ORDER BY `minOrder` ASC [ RunTime:0.023396s ]
select * from pdf where partno='2101607' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101607' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32728682 LIMIT 4 [ RunTime:0.020979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32728682 ORDER BY `minOrder` ASC [ RunTime:0.017391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32728682 ORDER BY `unit` DESC [ RunTime:0.027771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32728682 LIMIT 2 [ RunTime:0.006365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32728682 ORDER BY `minOrder` ASC [ RunTime:0.020591s ]
select * from pdf where partno='2107823' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107823' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32723622 LIMIT 4 [ RunTime:0.027644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32723622 ORDER BY `minOrder` ASC [ RunTime:0.045060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32723622 ORDER BY `unit` DESC [ RunTime:0.023941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32723622 LIMIT 2 [ RunTime:0.031789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32723622 ORDER BY `minOrder` ASC [ RunTime:0.009564s ]
select * from pdf where partno='2103244' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.049258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103244' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32715056 LIMIT 4 [ RunTime:0.041487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32715056 ORDER BY `minOrder` ASC [ RunTime:0.015901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32715056 ORDER BY `unit` DESC [ RunTime:0.031011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32715056 LIMIT 2 [ RunTime:0.019380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32715056 ORDER BY `minOrder` ASC [ RunTime:0.022711s ]
select * from pdf where partno='2105495' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105495' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32698729 LIMIT 4 [ RunTime:0.029632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32698729 ORDER BY `minOrder` ASC [ RunTime:0.040933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32698729 ORDER BY `unit` DESC [ RunTime:0.017270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32698729 LIMIT 2 [ RunTime:0.023696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32698729 ORDER BY `minOrder` ASC [ RunTime:0.010398s ]
select * from pdf where partno='2102583-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.020701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102583-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.036297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32696926 LIMIT 4 [ RunTime:0.024692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32696926 ORDER BY `minOrder` ASC [ RunTime:0.059239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32696926 ORDER BY `unit` DESC [ RunTime:0.011689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32696926 LIMIT 2 [ RunTime:0.018075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32696926 ORDER BY `minOrder` ASC [ RunTime:0.008249s ]
select * from pdf where partno='2102121' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102121' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32680670 LIMIT 4 [ RunTime:0.036199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32680670 ORDER BY `minOrder` ASC [ RunTime:0.030807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32680670 ORDER BY `unit` DESC [ RunTime:0.025307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32680670 LIMIT 2 [ RunTime:0.025602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32680670 ORDER BY `minOrder` ASC [ RunTime:0.038792s ]
select * from pdf where partno='2101762-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.047457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101762-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.014991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32677902 LIMIT 4 [ RunTime:0.021865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32677902 ORDER BY `minOrder` ASC [ RunTime:0.024186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32677902 ORDER BY `unit` DESC [ RunTime:0.031932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32677902 LIMIT 2 [ RunTime:0.072259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32677902 ORDER BY `minOrder` ASC [ RunTime:0.010705s ]
select * from pdf where partno='210001640' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.055377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001640' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.028556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32676964 LIMIT 4 [ RunTime:0.009093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32676964 ORDER BY `minOrder` ASC [ RunTime:0.062051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32676964 ORDER BY `unit` DESC [ RunTime:0.047333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32676964 LIMIT 2 [ RunTime:0.021766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32676964 ORDER BY `minOrder` ASC [ RunTime:0.010948s ]
select * from pdf where partno='210001096' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.013018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001096' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.044004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32670069 LIMIT 4 [ RunTime:0.046074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32670069 ORDER BY `minOrder` ASC [ RunTime:0.021045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32670069 ORDER BY `unit` DESC [ RunTime:0.027492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32670069 LIMIT 2 [ RunTime:0.017972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32670069 ORDER BY `minOrder` ASC [ RunTime:0.024795s ]
select * from pdf where partno='2107178' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107178' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32669206 LIMIT 4 [ RunTime:0.025149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32669206 ORDER BY `minOrder` ASC [ RunTime:0.017099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32669206 ORDER BY `unit` DESC [ RunTime:0.027259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32669206 LIMIT 2 [ RunTime:0.029771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32669206 ORDER BY `minOrder` ASC [ RunTime:0.019636s ]
select * from pdf where partno='210001099' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.035084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001099' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.027113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32662142 LIMIT 4 [ RunTime:0.017589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32662142 ORDER BY `minOrder` ASC [ RunTime:0.023980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32662142 ORDER BY `unit` DESC [ RunTime:0.008964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32662142 LIMIT 2 [ RunTime:0.027478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32662142 ORDER BY `minOrder` ASC [ RunTime:0.043419s ]
select * from pdf where partno='2102120' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.019200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102120' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32659274 LIMIT 4 [ RunTime:0.029585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32659274 ORDER BY `minOrder` ASC [ RunTime:0.018857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32659274 ORDER BY `unit` DESC [ RunTime:0.056714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32659274 LIMIT 2 [ RunTime:0.026229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32659274 ORDER BY `minOrder` ASC [ RunTime:0.006970s ]
select * from pdf where partno='2100538' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.044895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100538' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.062966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32659273 LIMIT 4 [ RunTime:0.056914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32659273 ORDER BY `minOrder` ASC [ RunTime:0.091490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32659273 ORDER BY `unit` DESC [ RunTime:0.113663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32659273 LIMIT 2 [ RunTime:0.033678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32659273 ORDER BY `minOrder` ASC [ RunTime:0.022522s ]
select * from pdf where partno='2100536' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.075287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100536' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32651618 LIMIT 4 [ RunTime:0.073240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32651618 ORDER BY `minOrder` ASC [ RunTime:0.017119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32651618 ORDER BY `unit` DESC [ RunTime:0.066168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32651618 LIMIT 2 [ RunTime:0.039110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32651618 ORDER BY `minOrder` ASC [ RunTime:0.021217s ]
select * from pdf where partno='2104747' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104747' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.070176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32651381 LIMIT 4 [ RunTime:0.009495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32651381 ORDER BY `minOrder` ASC [ RunTime:0.041672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32651381 ORDER BY `unit` DESC [ RunTime:0.062963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32651381 LIMIT 2 [ RunTime:0.010104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32651381 ORDER BY `minOrder` ASC [ RunTime:0.027274s ]
select * from pdf where partno='2108120' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108120' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.052803s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.057195s ]