SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001515s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=12190&search=1' [ RunTime:0.002598s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001157s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000454s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001783s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.002565s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002751s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000387s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002699s ]
SELECT * FROM `stock_search` WHERE `partno` = '12190' LIMIT 1 [ RunTime:0.001248s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 18:26:34' WHERE `partno` = '12190' [ RunTime:0.008457s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003131s ]
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 '12190%' OR `brand` LIKE '12190%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007356s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763547 LIMIT 5 [ RunTime:0.003475s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763547 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763547 ORDER BY `unit` DESC [ RunTime:0.010364s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763547 LIMIT 2 [ RunTime:0.002153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763547 ORDER BY `minOrder` ASC [ RunTime:0.003847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656911 LIMIT 5 [ RunTime:0.001262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656911 ORDER BY `minOrder` ASC [ RunTime:0.002467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19656911 ORDER BY `unit` DESC [ RunTime:0.002396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19656911 LIMIT 2 [ RunTime:0.003961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656911 ORDER BY `minOrder` ASC [ RunTime:0.001840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837418 LIMIT 5 [ RunTime:0.005825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837418 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837418 ORDER BY `unit` DESC [ RunTime:0.001132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837418 LIMIT 2 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837418 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837403 LIMIT 5 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837403 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837403 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837403 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837403 ORDER BY `minOrder` ASC [ RunTime:0.005635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836809 LIMIT 5 [ RunTime:0.012449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836809 ORDER BY `minOrder` ASC [ RunTime:0.030445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836809 ORDER BY `unit` DESC [ RunTime:0.028941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836809 LIMIT 2 [ RunTime:0.031612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836809 ORDER BY `minOrder` ASC [ RunTime:0.002788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021317 LIMIT 5 [ RunTime:0.009768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021317 ORDER BY `minOrder` ASC [ RunTime:0.001873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17021317 ORDER BY `unit` DESC [ RunTime:0.003631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17021317 LIMIT 2 [ RunTime:0.007174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021317 ORDER BY `minOrder` ASC [ RunTime:0.001361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021266 LIMIT 5 [ RunTime:0.008610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021266 ORDER BY `minOrder` ASC [ RunTime:0.012094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17021266 ORDER BY `unit` DESC [ RunTime:0.005756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17021266 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021266 ORDER BY `minOrder` ASC [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505318 LIMIT 5 [ RunTime:0.002414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16505318 ORDER BY `minOrder` ASC [ RunTime:0.007007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16505318 ORDER BY `unit` DESC [ RunTime:0.002614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16505318 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16505318 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505313 LIMIT 5 [ RunTime:0.006464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16505313 ORDER BY `minOrder` ASC [ RunTime:0.005170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16505313 ORDER BY `unit` DESC [ RunTime:0.000728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16505313 LIMIT 2 [ RunTime:0.012283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16505313 ORDER BY `minOrder` ASC [ RunTime:0.004062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505310 LIMIT 5 [ RunTime:0.002733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16505310 ORDER BY `minOrder` ASC [ RunTime:0.009847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16505310 ORDER BY `unit` DESC [ RunTime:0.002516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16505310 LIMIT 2 [ RunTime:0.005170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16505310 ORDER BY `minOrder` ASC [ RunTime:0.008700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14525591 LIMIT 5 [ RunTime:0.001510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14525591 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14525591 ORDER BY `unit` DESC [ RunTime:0.009038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14525591 LIMIT 2 [ RunTime:0.009228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14525591 ORDER BY `minOrder` ASC [ RunTime:0.007548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14525587 LIMIT 5 [ RunTime:0.002089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14525587 ORDER BY `minOrder` ASC [ RunTime:0.004393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14525587 ORDER BY `unit` DESC [ RunTime:0.002738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14525587 LIMIT 2 [ RunTime:0.022043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14525587 ORDER BY `minOrder` ASC [ RunTime:0.005638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14525584 LIMIT 5 [ RunTime:0.003910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14525584 ORDER BY `minOrder` ASC [ RunTime:0.001279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14525584 ORDER BY `unit` DESC [ RunTime:0.004944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14525584 LIMIT 2 [ RunTime:0.002066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14525584 ORDER BY `minOrder` ASC [ RunTime:0.004767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14347865 LIMIT 5 [ RunTime:0.008865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14347865 ORDER BY `minOrder` ASC [ RunTime:0.009002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14347865 ORDER BY `unit` DESC [ RunTime:0.008396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14347865 LIMIT 2 [ RunTime:0.006543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14347865 ORDER BY `minOrder` ASC [ RunTime:0.002860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657094 LIMIT 5 [ RunTime:0.000956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13657094 ORDER BY `minOrder` ASC [ RunTime:0.005420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13657094 ORDER BY `unit` DESC [ RunTime:0.002439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13657094 LIMIT 2 [ RunTime:0.007386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13657094 ORDER BY `minOrder` ASC [ RunTime:0.006201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657089 LIMIT 5 [ RunTime:0.003632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13657089 ORDER BY `minOrder` ASC [ RunTime:0.014161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13657089 ORDER BY `unit` DESC [ RunTime:0.042414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13657089 LIMIT 2 [ RunTime:0.004211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13657089 ORDER BY `minOrder` ASC [ RunTime:0.002420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657088 LIMIT 5 [ RunTime:0.004494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13657088 ORDER BY `minOrder` ASC [ RunTime:0.004676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13657088 ORDER BY `unit` DESC [ RunTime:0.001568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13657088 LIMIT 2 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13657088 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657085 LIMIT 5 [ RunTime:0.005391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13657085 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13657085 ORDER BY `unit` DESC [ RunTime:0.000463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13657085 LIMIT 2 [ RunTime:0.020672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13657085 ORDER BY `minOrder` ASC [ RunTime:0.008505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104250 LIMIT 5 [ RunTime:0.007585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104250 ORDER BY `minOrder` ASC [ RunTime:0.008926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13104250 ORDER BY `unit` DESC [ RunTime:0.009189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13104250 LIMIT 2 [ RunTime:0.006100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104250 ORDER BY `minOrder` ASC [ RunTime:0.002917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12197551 LIMIT 5 [ RunTime:0.007347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12197551 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12197551 ORDER BY `unit` DESC [ RunTime:0.011057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12197551 LIMIT 2 [ RunTime:0.004375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12197551 ORDER BY `minOrder` ASC [ RunTime:0.010297s ]
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 '12190%' OR `brand` LIKE '12190%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006378s ]
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 '12190%' OR `brand` LIKE '12190%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57746340 LIMIT 5 [ RunTime:0.021825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57746340 ORDER BY `minOrder` ASC [ RunTime:0.010417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57746340 ORDER BY `unit` DESC [ RunTime:0.006758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57746340 LIMIT 2 [ RunTime:0.022930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57746340 ORDER BY `minOrder` ASC [ RunTime:0.021194s ]
select * from pdf where partno='12190CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.015481s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12190CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.022751s ]
SELECT `id` FROM `stock` WHERE `id` <> 57746340 AND `partno` = '12190CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.015496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63336473 LIMIT 5 [ RunTime:0.012380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336473 ORDER BY `minOrder` ASC [ RunTime:0.012439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63336473 ORDER BY `unit` DESC [ RunTime:0.028350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63336473 LIMIT 2 [ RunTime:0.041339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336473 ORDER BY `minOrder` ASC [ RunTime:0.020543s ]
select * from pdf where partno='1219064' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219064' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013067s ]
SELECT `id` FROM `stock` WHERE `id` <> 63336473 AND `partno` = '1219064' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11201104 [ RunTime:0.041291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60391484 LIMIT 5 [ RunTime:0.034262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391484 ORDER BY `minOrder` ASC [ RunTime:0.016447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60391484 ORDER BY `unit` DESC [ RunTime:0.008426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60391484 LIMIT 2 [ RunTime:0.010650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391484 ORDER BY `minOrder` ASC [ RunTime:0.041272s ]
select * from pdf where partno='1219070000' and brandshort='Weidmüller' limit 1 [ RunTime:0.020122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219070000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.050255s ]
SELECT `id` FROM `stock` WHERE `id` <> 60391484 AND `partno` = '1219070000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.054455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851779 [ RunTime:0.066503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60391402 LIMIT 5 [ RunTime:0.022986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391402 ORDER BY `minOrder` ASC [ RunTime:0.014262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60391402 ORDER BY `unit` DESC [ RunTime:0.034623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60391402 LIMIT 2 [ RunTime:0.039655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391402 ORDER BY `minOrder` ASC [ RunTime:0.018759s ]
select * from pdf where partno='1219060000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219060000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.062219s ]
SELECT `id` FROM `stock` WHERE `id` <> 60391402 AND `partno` = '1219060000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.029955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851705 [ RunTime:0.028898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60391316 LIMIT 5 [ RunTime:0.040067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391316 ORDER BY `minOrder` ASC [ RunTime:0.011257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60391316 ORDER BY `unit` DESC [ RunTime:0.014044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60391316 LIMIT 2 [ RunTime:0.019026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391316 ORDER BY `minOrder` ASC [ RunTime:0.015556s ]
select * from pdf where partno='1219050000' and brandshort='Weidmüller' limit 1 [ RunTime:0.038070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219050000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.017855s ]
SELECT `id` FROM `stock` WHERE `id` <> 60391316 AND `partno` = '1219050000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60391233 LIMIT 5 [ RunTime:0.048065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391233 ORDER BY `minOrder` ASC [ RunTime:0.016536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60391233 ORDER BY `unit` DESC [ RunTime:0.059554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60391233 LIMIT 2 [ RunTime:0.047135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391233 ORDER BY `minOrder` ASC [ RunTime:0.061537s ]
select * from pdf where partno='1219040000' and brandshort='Weidmüller' limit 1 [ RunTime:0.020140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219040000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.034202s ]
SELECT `id` FROM `stock` WHERE `id` <> 60391233 AND `partno` = '1219040000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104250 [ RunTime:0.027143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60391081 LIMIT 5 [ RunTime:0.025138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391081 ORDER BY `minOrder` ASC [ RunTime:0.012312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60391081 ORDER BY `unit` DESC [ RunTime:0.014063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60391081 LIMIT 2 [ RunTime:0.011644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391081 ORDER BY `minOrder` ASC [ RunTime:0.041823s ]
select * from pdf where partno='1219020000' and brandshort='Weidmüller' limit 1 [ RunTime:0.024193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219020000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.029697s ]
SELECT `id` FROM `stock` WHERE `id` <> 60391081 AND `partno` = '1219020000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.031605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851544 [ RunTime:0.036792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60388963 LIMIT 5 [ RunTime:0.044389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60388963 ORDER BY `minOrder` ASC [ RunTime:0.048604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60388963 ORDER BY `unit` DESC [ RunTime:0.076607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60388963 LIMIT 2 [ RunTime:0.014426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60388963 ORDER BY `minOrder` ASC [ RunTime:0.038416s ]
select * from pdf where partno='1219030000' and brandshort='Weidmüller' limit 1 [ RunTime:0.022980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219030000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.044895s ]
SELECT `id` FROM `stock` WHERE `id` <> 60388963 AND `partno` = '1219030000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851556 [ RunTime:0.001501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58543303 LIMIT 5 [ RunTime:0.015946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58543303 ORDER BY `minOrder` ASC [ RunTime:0.010090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58543303 ORDER BY `unit` DESC [ RunTime:0.017024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58543303 LIMIT 2 [ RunTime:0.003830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58543303 ORDER BY `minOrder` ASC [ RunTime:0.002488s ]
select * from pdf where partno='1219092' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219092' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.033418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58299143 LIMIT 5 [ RunTime:0.010029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58299143 ORDER BY `minOrder` ASC [ RunTime:0.005582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58299143 ORDER BY `unit` DESC [ RunTime:0.053295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58299143 LIMIT 2 [ RunTime:0.022555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58299143 ORDER BY `minOrder` ASC [ RunTime:0.000681s ]
select * from pdf where partno='12190' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.021105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12190' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.078450s ]
SELECT `id` FROM `stock` WHERE `id` <> 58299143 AND `partno` = '12190' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.037995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14347865 [ RunTime:0.064460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701816 LIMIT 5 [ RunTime:0.026952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701816 ORDER BY `minOrder` ASC [ RunTime:0.037684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701816 ORDER BY `unit` DESC [ RunTime:0.038344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701816 LIMIT 2 [ RunTime:0.038495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701816 ORDER BY `minOrder` ASC [ RunTime:0.023966s ]
select * from pdf where partno='121908' and brandshort='Brady Corporation' limit 1 [ RunTime:0.061580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121908' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.055236s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701816 AND `partno` = '121908' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.015151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505318 [ RunTime:0.027554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701811 LIMIT 5 [ RunTime:0.056519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701811 ORDER BY `minOrder` ASC [ RunTime:0.020119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701811 ORDER BY `unit` DESC [ RunTime:0.020193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701811 LIMIT 2 [ RunTime:0.037577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701811 ORDER BY `minOrder` ASC [ RunTime:0.035262s ]
select * from pdf where partno='121902' and brandshort='Brady Corporation' limit 1 [ RunTime:0.027491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121902' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.022104s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701811 AND `partno` = '121902' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.018753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657094 [ RunTime:0.014645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701808 LIMIT 5 [ RunTime:0.030646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701808 ORDER BY `minOrder` ASC [ RunTime:0.034213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701808 ORDER BY `unit` DESC [ RunTime:0.042294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701808 LIMIT 2 [ RunTime:0.013534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701808 ORDER BY `minOrder` ASC [ RunTime:0.020546s ]
select * from pdf where partno='121906' and brandshort='Brady Corporation' limit 1 [ RunTime:0.016796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121906' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010260s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701808 AND `partno` = '121906' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.015810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14525591 [ RunTime:0.022707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701802 LIMIT 5 [ RunTime:0.024813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701802 ORDER BY `minOrder` ASC [ RunTime:0.012099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701802 ORDER BY `unit` DESC [ RunTime:0.026492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701802 LIMIT 2 [ RunTime:0.020131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701802 ORDER BY `minOrder` ASC [ RunTime:0.011558s ]
select * from pdf where partno='121907' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121907' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.013990s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701802 AND `partno` = '121907' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505313 [ RunTime:0.001619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701798 LIMIT 5 [ RunTime:0.014365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701798 ORDER BY `minOrder` ASC [ RunTime:0.006406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701798 ORDER BY `unit` DESC [ RunTime:0.022530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701798 LIMIT 2 [ RunTime:0.018008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701798 ORDER BY `minOrder` ASC [ RunTime:0.014426s ]
select * from pdf where partno='121909' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121909' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005497s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701798 AND `partno` = '121909' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.019757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14525587 [ RunTime:0.015320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701796 LIMIT 5 [ RunTime:0.017636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701796 ORDER BY `minOrder` ASC [ RunTime:0.006939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701796 ORDER BY `unit` DESC [ RunTime:0.016096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701796 LIMIT 2 [ RunTime:0.052108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701796 ORDER BY `minOrder` ASC [ RunTime:0.027164s ]
select * from pdf where partno='121903' and brandshort='Brady Corporation' limit 1 [ RunTime:0.026717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121903' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.027133s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701796 AND `partno` = '121903' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.071628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657089 [ RunTime:0.017494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701795 LIMIT 5 [ RunTime:0.012404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701795 ORDER BY `minOrder` ASC [ RunTime:0.015396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701795 ORDER BY `unit` DESC [ RunTime:0.012040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701795 LIMIT 2 [ RunTime:0.023949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701795 ORDER BY `minOrder` ASC [ RunTime:0.023705s ]
select * from pdf where partno='121901' and brandshort='Brady Corporation' limit 1 [ RunTime:0.014529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121901' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008564s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701795 AND `partno` = '121901' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657088 [ RunTime:0.026143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701794 LIMIT 5 [ RunTime:0.044978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701794 ORDER BY `minOrder` ASC [ RunTime:0.015056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701794 ORDER BY `unit` DESC [ RunTime:0.013398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701794 LIMIT 2 [ RunTime:0.068874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701794 ORDER BY `minOrder` ASC [ RunTime:0.003255s ]
select * from pdf where partno='121904' and brandshort='Brady Corporation' limit 1 [ RunTime:0.011285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121904' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.040499s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701794 AND `partno` = '121904' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.030020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505310 [ RunTime:0.010927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701790 LIMIT 5 [ RunTime:0.040960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701790 ORDER BY `minOrder` ASC [ RunTime:0.020608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701790 ORDER BY `unit` DESC [ RunTime:0.029235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701790 LIMIT 2 [ RunTime:0.029847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701790 ORDER BY `minOrder` ASC [ RunTime:0.011041s ]
select * from pdf where partno='121900' and brandshort='Brady Corporation' limit 1 [ RunTime:0.052518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121900' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.021099s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701790 AND `partno` = '121900' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14525584 [ RunTime:0.018110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701786 LIMIT 5 [ RunTime:0.021813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701786 ORDER BY `minOrder` ASC [ RunTime:0.003884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701786 ORDER BY `unit` DESC [ RunTime:0.013268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701786 LIMIT 2 [ RunTime:0.038665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701786 ORDER BY `minOrder` ASC [ RunTime:0.024230s ]
select * from pdf where partno='121905' and brandshort='Brady Corporation' limit 1 [ RunTime:0.046478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121905' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.018999s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701786 AND `partno` = '121905' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657085 [ RunTime:0.000832s ]
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 '12190%' OR `brand` LIKE '12190%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022250s ]
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 '12190%' OR `brand` LIKE '12190%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005139s ]
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 '12190%' OR `brand` LIKE '12190%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017581s ]
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 '12190%' OR `brand` LIKE '12190%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001174s ]
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 '12190%' OR `brand` LIKE '12190%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002220s ]
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 '12190%' OR `brand` LIKE '12190%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006097s ]
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 '12190%' OR `brand` LIKE '12190%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001278s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12190%' OR `brand` LIKE '12190%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001366s ]