SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001832s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.15' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=10672&search=1' [ RunTime:0.003323s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001735s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004469s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001484s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.15' ) [ RunTime:0.008758s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001592s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.017683s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002531s ]
SELECT * FROM `stock_search` WHERE `partno` = '10672' LIMIT 1 [ RunTime:0.017892s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-14 03:09:37' WHERE `partno` = '10672' [ RunTime:0.011991s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002689s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073083s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13373017 LIMIT 5 [ RunTime:0.049772s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13373017 ORDER BY `minOrder` ASC [ RunTime:0.011001s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.030459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13373017 ORDER BY `unit` DESC [ RunTime:0.059385s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13373017 LIMIT 2 [ RunTime:0.026200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13373017 ORDER BY `minOrder` ASC [ RunTime:0.015983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187137 LIMIT 5 [ RunTime:0.028632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187137 ORDER BY `minOrder` ASC [ RunTime:0.050131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187137 ORDER BY `unit` DESC [ RunTime:0.018981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187137 LIMIT 2 [ RunTime:0.063024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187137 ORDER BY `minOrder` ASC [ RunTime:0.015793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784331 LIMIT 5 [ RunTime:0.040085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784331 ORDER BY `minOrder` ASC [ RunTime:0.031300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784331 ORDER BY `unit` DESC [ RunTime:0.023550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784331 LIMIT 2 [ RunTime:0.043622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784331 ORDER BY `minOrder` ASC [ RunTime:0.012300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982550 LIMIT 5 [ RunTime:0.041728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982550 ORDER BY `minOrder` ASC [ RunTime:0.045665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982550 ORDER BY `unit` DESC [ RunTime:0.056520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982550 LIMIT 2 [ RunTime:0.026388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982550 ORDER BY `minOrder` ASC [ RunTime:0.022952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982490 LIMIT 5 [ RunTime:0.095052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982490 ORDER BY `minOrder` ASC [ RunTime:0.084079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982490 ORDER BY `unit` DESC [ RunTime:0.078366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982490 LIMIT 2 [ RunTime:0.108566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982490 ORDER BY `minOrder` ASC [ RunTime:0.003104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982486 LIMIT 5 [ RunTime:0.072925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982486 ORDER BY `minOrder` ASC [ RunTime:0.044543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982486 ORDER BY `unit` DESC [ RunTime:0.054575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982486 LIMIT 2 [ RunTime:0.066483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982486 ORDER BY `minOrder` ASC [ RunTime:0.008656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982193 LIMIT 5 [ RunTime:0.041859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982193 ORDER BY `minOrder` ASC [ RunTime:0.019372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982193 ORDER BY `unit` DESC [ RunTime:0.044478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982193 LIMIT 2 [ RunTime:0.091204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982193 ORDER BY `minOrder` ASC [ RunTime:0.065619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981536 LIMIT 5 [ RunTime:0.009421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981536 ORDER BY `minOrder` ASC [ RunTime:0.048431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981536 ORDER BY `unit` DESC [ RunTime:0.030541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981536 LIMIT 2 [ RunTime:0.030350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981536 ORDER BY `minOrder` ASC [ RunTime:0.014544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981404 LIMIT 5 [ RunTime:0.031772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981404 ORDER BY `minOrder` ASC [ RunTime:0.014567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981404 ORDER BY `unit` DESC [ RunTime:0.036626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981404 LIMIT 2 [ RunTime:0.039745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981404 ORDER BY `minOrder` ASC [ RunTime:0.026375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981225 LIMIT 5 [ RunTime:0.015991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981225 ORDER BY `minOrder` ASC [ RunTime:0.047395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981225 ORDER BY `unit` DESC [ RunTime:0.033546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981225 LIMIT 2 [ RunTime:0.011229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981225 ORDER BY `minOrder` ASC [ RunTime:0.005055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18978983 LIMIT 5 [ RunTime:0.019971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18978983 ORDER BY `minOrder` ASC [ RunTime:0.025024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18978983 ORDER BY `unit` DESC [ RunTime:0.010306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18978983 LIMIT 2 [ RunTime:0.014220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18978983 ORDER BY `minOrder` ASC [ RunTime:0.006559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974964 LIMIT 5 [ RunTime:0.022796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974964 ORDER BY `minOrder` ASC [ RunTime:0.024120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974964 ORDER BY `unit` DESC [ RunTime:0.018765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974964 LIMIT 2 [ RunTime:0.007807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974964 ORDER BY `minOrder` ASC [ RunTime:0.017576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974963 LIMIT 5 [ RunTime:0.037611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974963 ORDER BY `minOrder` ASC [ RunTime:0.047333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974963 ORDER BY `unit` DESC [ RunTime:0.043156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974963 LIMIT 2 [ RunTime:0.010257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974963 ORDER BY `minOrder` ASC [ RunTime:0.034651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797327 LIMIT 5 [ RunTime:0.075520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797327 ORDER BY `minOrder` ASC [ RunTime:0.041973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797327 ORDER BY `unit` DESC [ RunTime:0.018417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797327 LIMIT 2 [ RunTime:0.028671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797327 ORDER BY `minOrder` ASC [ RunTime:0.028404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793332 LIMIT 5 [ RunTime:0.079536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793332 ORDER BY `minOrder` ASC [ RunTime:0.045591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18793332 ORDER BY `unit` DESC [ RunTime:0.061030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18793332 LIMIT 2 [ RunTime:0.048906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793332 ORDER BY `minOrder` ASC [ RunTime:0.022969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793331 LIMIT 5 [ RunTime:0.038854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793331 ORDER BY `minOrder` ASC [ RunTime:0.061189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18793331 ORDER BY `unit` DESC [ RunTime:0.011962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18793331 LIMIT 2 [ RunTime:0.043165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793331 ORDER BY `minOrder` ASC [ RunTime:0.001791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792938 LIMIT 5 [ RunTime:0.005286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792938 ORDER BY `minOrder` ASC [ RunTime:0.009665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792938 ORDER BY `unit` DESC [ RunTime:0.030950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792938 LIMIT 2 [ RunTime:0.022102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792938 ORDER BY `minOrder` ASC [ RunTime:0.011564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775547 LIMIT 5 [ RunTime:0.028460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775547 ORDER BY `minOrder` ASC [ RunTime:0.025939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775547 ORDER BY `unit` DESC [ RunTime:0.011301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775547 LIMIT 2 [ RunTime:0.015050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775547 ORDER BY `minOrder` ASC [ RunTime:0.008254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773961 LIMIT 5 [ RunTime:0.006607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773961 ORDER BY `minOrder` ASC [ RunTime:0.003923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773961 ORDER BY `unit` DESC [ RunTime:0.008494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773961 LIMIT 2 [ RunTime:0.016614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773961 ORDER BY `minOrder` ASC [ RunTime:0.001984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772958 LIMIT 5 [ RunTime:0.003261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772958 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772958 ORDER BY `unit` DESC [ RunTime:0.012243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772958 LIMIT 2 [ RunTime:0.012346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772958 ORDER BY `minOrder` ASC [ RunTime:0.006699s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082061 LIMIT 5 [ RunTime:0.032415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082061 ORDER BY `minOrder` ASC [ RunTime:0.027022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082061 ORDER BY `unit` DESC [ RunTime:0.031577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082061 LIMIT 2 [ RunTime:0.024701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082061 ORDER BY `minOrder` ASC [ RunTime:0.011050s ]
select * from pdf where partno='1067250000' and brandshort='weidmuller' limit 1 [ RunTime:0.030856s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067250000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.060464s ]
SELECT `id` FROM `stock` WHERE `id` <> 51082061 AND `partno` = '1067250000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.036661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212167 [ RunTime:0.030631s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212167 LIMIT 5 [ RunTime:0.049842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212167 ORDER BY `minOrder` ASC [ RunTime:0.027026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212167 ORDER BY `unit` DESC [ RunTime:0.014126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212167 LIMIT 2 [ RunTime:0.026181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212167 ORDER BY `minOrder` ASC [ RunTime:0.005388s ]
select * from pdf where partno='1067250000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067250000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.033256s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212167 AND `partno` = '1067250000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.036648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082061 [ RunTime:0.026553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335286 LIMIT 5 [ RunTime:0.013170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335286 ORDER BY `minOrder` ASC [ RunTime:0.040480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335286 ORDER BY `unit` DESC [ RunTime:0.081791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335286 LIMIT 2 [ RunTime:0.032732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335286 ORDER BY `minOrder` ASC [ RunTime:0.050125s ]
select * from pdf where partno='1067297' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067297' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011197s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335286 AND `partno` = '1067297' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.037719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784331 [ RunTime:0.036051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335281 LIMIT 5 [ RunTime:0.029056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335281 ORDER BY `minOrder` ASC [ RunTime:0.026458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335281 ORDER BY `unit` DESC [ RunTime:0.050223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335281 LIMIT 2 [ RunTime:0.003783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335281 ORDER BY `minOrder` ASC [ RunTime:0.003054s ]
select * from pdf where partno='1067295' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067295' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.026986s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335281 AND `partno` = '1067295' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.048394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786429 LIMIT 5 [ RunTime:0.038892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786429 ORDER BY `minOrder` ASC [ RunTime:0.033150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786429 ORDER BY `unit` DESC [ RunTime:0.000988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786429 LIMIT 2 [ RunTime:0.021199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786429 ORDER BY `minOrder` ASC [ RunTime:0.012523s ]
select * from pdf where partno='1067200' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067200' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005982s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786429 AND `partno` = '1067200' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797327 [ RunTime:0.009642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63331096 LIMIT 5 [ RunTime:0.010461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63331096 ORDER BY `minOrder` ASC [ RunTime:0.018554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63331096 ORDER BY `unit` DESC [ RunTime:0.006673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63331096 LIMIT 2 [ RunTime:0.004666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63331096 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
select * from pdf where partno='1067299' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067299' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011474s ]
SELECT `id` FROM `stock` WHERE `id` <> 63331096 AND `partno` = '1067299' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13373017 [ RunTime:0.001568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64808149 LIMIT 5 [ RunTime:0.002424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808149 ORDER BY `minOrder` ASC [ RunTime:0.008640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64808149 ORDER BY `unit` DESC [ RunTime:0.011762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64808149 LIMIT 2 [ RunTime:0.032406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808149 ORDER BY `minOrder` ASC [ RunTime:0.010381s ]
select * from pdf where partno='1067262' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067262' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012090s ]
SELECT `id` FROM `stock` WHERE `id` <> 64808149 AND `partno` = '1067262' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775547 [ RunTime:0.013581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805695 LIMIT 5 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805695 ORDER BY `minOrder` ASC [ RunTime:0.004590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805695 ORDER BY `unit` DESC [ RunTime:0.007724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805695 LIMIT 2 [ RunTime:0.006676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805695 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='1067273' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067273' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019821s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805695 AND `partno` = '1067273' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773961 [ RunTime:0.001121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805598 LIMIT 5 [ RunTime:0.015463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805598 ORDER BY `minOrder` ASC [ RunTime:0.002398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805598 ORDER BY `unit` DESC [ RunTime:0.006152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805598 LIMIT 2 [ RunTime:0.003658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805598 ORDER BY `minOrder` ASC [ RunTime:0.005865s ]
select * from pdf where partno='1067264' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067264' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021394s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805598 AND `partno` = '1067264' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010699 [ RunTime:0.016793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803802 LIMIT 5 [ RunTime:0.010347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803802 ORDER BY `minOrder` ASC [ RunTime:0.008182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803802 ORDER BY `unit` DESC [ RunTime:0.003684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803802 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803802 ORDER BY `minOrder` ASC [ RunTime:0.001018s ]
select * from pdf where partno='1067272' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067272' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018075s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803802 AND `partno` = '1067272' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.024235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14180117 [ RunTime:0.010792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803734 LIMIT 5 [ RunTime:0.000878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803734 ORDER BY `minOrder` ASC [ RunTime:0.003402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803734 ORDER BY `unit` DESC [ RunTime:0.001937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803734 LIMIT 2 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803734 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='1067275' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067275' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007376s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803734 AND `partno` = '1067275' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772958 [ RunTime:0.003551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802203 LIMIT 5 [ RunTime:0.007115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802203 ORDER BY `minOrder` ASC [ RunTime:0.010856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802203 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802203 LIMIT 2 [ RunTime:0.013231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802203 ORDER BY `minOrder` ASC [ RunTime:0.003345s ]
select * from pdf where partno='1067298' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067298' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012560s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802203 AND `partno` = '1067298' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771988 [ RunTime:0.001805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64788225 LIMIT 5 [ RunTime:0.012458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788225 ORDER BY `minOrder` ASC [ RunTime:0.009781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64788225 ORDER BY `unit` DESC [ RunTime:0.002862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64788225 LIMIT 2 [ RunTime:0.006073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788225 ORDER BY `minOrder` ASC [ RunTime:0.010102s ]
select * from pdf where partno='1067235' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067235' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005308s ]
SELECT `id` FROM `stock` WHERE `id` <> 64788225 AND `partno` = '1067235' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793332 [ RunTime:0.001292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64788224 LIMIT 5 [ RunTime:0.001578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788224 ORDER BY `minOrder` ASC [ RunTime:0.002740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64788224 ORDER BY `unit` DESC [ RunTime:0.003583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64788224 LIMIT 2 [ RunTime:0.015729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788224 ORDER BY `minOrder` ASC [ RunTime:0.002205s ]
select * from pdf where partno='1067226' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067226' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003512s ]
SELECT `id` FROM `stock` WHERE `id` <> 64788224 AND `partno` = '1067226' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793331 [ RunTime:0.002961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787692 LIMIT 5 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787692 ORDER BY `minOrder` ASC [ RunTime:0.007012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787692 ORDER BY `unit` DESC [ RunTime:0.001321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787692 LIMIT 2 [ RunTime:0.012723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787692 ORDER BY `minOrder` ASC [ RunTime:0.002803s ]
select * from pdf where partno='1067222' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067222' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000738s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787692 AND `partno` = '1067222' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792938 [ RunTime:0.007203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787691 LIMIT 5 [ RunTime:0.001561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787691 ORDER BY `minOrder` ASC [ RunTime:0.002404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787691 ORDER BY `unit` DESC [ RunTime:0.000706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787691 LIMIT 2 [ RunTime:0.000977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787691 ORDER BY `minOrder` ASC [ RunTime:0.005052s ]
select * from pdf where partno='1067207' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067207' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001404s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787691 AND `partno` = '1067207' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227580 [ RunTime:0.001607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787690 LIMIT 5 [ RunTime:0.002076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787690 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787690 ORDER BY `unit` DESC [ RunTime:0.002543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787690 LIMIT 2 [ RunTime:0.003221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787690 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
select * from pdf where partno='1067206' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067206' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006615s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787690 AND `partno` = '1067206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227579 [ RunTime:0.000631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787571 LIMIT 5 [ RunTime:0.002686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787571 ORDER BY `minOrder` ASC [ RunTime:0.003217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787571 ORDER BY `unit` DESC [ RunTime:0.004011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787571 LIMIT 2 [ RunTime:0.004814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787571 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
select * from pdf where partno='1067203' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067203' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004076s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787571 AND `partno` = '1067203' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227559 [ RunTime:0.002028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64780477 LIMIT 5 [ RunTime:0.001098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64780477 ORDER BY `minOrder` ASC [ RunTime:0.000924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64780477 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64780477 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64780477 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
select * from pdf where partno='1067293' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067293' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002906s ]
SELECT `id` FROM `stock` WHERE `id` <> 64780477 AND `partno` = '1067293' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187150 [ RunTime:0.000978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64118323 LIMIT 5 [ RunTime:0.003041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64118323 ORDER BY `minOrder` ASC [ RunTime:0.006198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64118323 ORDER BY `unit` DESC [ RunTime:0.000735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64118323 LIMIT 2 [ RunTime:0.001006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64118323 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='1067230000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067230000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001157s ]
SELECT `id` FROM `stock` WHERE `id` <> 64118323 AND `partno` = '1067230000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12072058 [ RunTime:0.005127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63382130 LIMIT 5 [ RunTime:0.004841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63382130 ORDER BY `minOrder` ASC [ RunTime:0.001689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63382130 ORDER BY `unit` DESC [ RunTime:0.001770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63382130 LIMIT 2 [ RunTime:0.001521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63382130 ORDER BY `minOrder` ASC [ RunTime:0.003749s ]
select * from pdf where partno='10672' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.005683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10672' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.014229s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007703s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002160s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007692s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001447s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007224s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006351s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001236s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10672%' OR `brand` LIKE '10672%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002799s ]