SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001319s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=21120&search=1' [ RunTime:0.034836s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001126s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.013328s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002536s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.011395s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002455s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.017746s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002222s ]
SELECT * FROM `stock_search` WHERE `partno` = '21120' LIMIT 1 [ RunTime:0.039589s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-27 19:29:03' WHERE `partno` = '21120' [ RunTime:0.018903s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003861s ]
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 '21120%' OR `brand` LIKE '21120%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064369s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616105 LIMIT 5 [ RunTime:0.066863s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.025201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616105 ORDER BY `minOrder` ASC [ RunTime:0.031175s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616105 ORDER BY `unit` DESC [ RunTime:0.037706s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.023118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616105 LIMIT 2 [ RunTime:0.022348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616105 ORDER BY `minOrder` ASC [ RunTime:0.019503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616534 LIMIT 5 [ RunTime:0.029911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616534 ORDER BY `minOrder` ASC [ RunTime:0.058877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616534 ORDER BY `unit` DESC [ RunTime:0.056308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616534 LIMIT 2 [ RunTime:0.031027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616534 ORDER BY `minOrder` ASC [ RunTime:0.021612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612993 LIMIT 5 [ RunTime:0.068384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612993 ORDER BY `minOrder` ASC [ RunTime:0.054082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612993 ORDER BY `unit` DESC [ RunTime:0.050780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612993 LIMIT 2 [ RunTime:0.035266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612993 ORDER BY `minOrder` ASC [ RunTime:0.050892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613739 LIMIT 5 [ RunTime:0.018579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613739 ORDER BY `minOrder` ASC [ RunTime:0.040119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613739 ORDER BY `unit` DESC [ RunTime:0.039374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613739 LIMIT 2 [ RunTime:0.113691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613739 ORDER BY `minOrder` ASC [ RunTime:0.014697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19009865 LIMIT 5 [ RunTime:0.042502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19009865 ORDER BY `minOrder` ASC [ RunTime:0.041761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19009865 ORDER BY `unit` DESC [ RunTime:0.008815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19009865 LIMIT 2 [ RunTime:0.019585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19009865 ORDER BY `minOrder` ASC [ RunTime:0.019049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19006016 LIMIT 5 [ RunTime:0.028837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19006016 ORDER BY `minOrder` ASC [ RunTime:0.008295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19006016 ORDER BY `unit` DESC [ RunTime:0.010914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19006016 LIMIT 2 [ RunTime:0.031400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19006016 ORDER BY `minOrder` ASC [ RunTime:0.013330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18844149 LIMIT 5 [ RunTime:0.015339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18844149 ORDER BY `minOrder` ASC [ RunTime:0.026269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18844149 ORDER BY `unit` DESC [ RunTime:0.017021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18844149 LIMIT 2 [ RunTime:0.029775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18844149 ORDER BY `minOrder` ASC [ RunTime:0.007410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055079 LIMIT 5 [ RunTime:0.019005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17055079 ORDER BY `minOrder` ASC [ RunTime:0.047795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17055079 ORDER BY `unit` DESC [ RunTime:0.016484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17055079 LIMIT 2 [ RunTime:0.007776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17055079 ORDER BY `minOrder` ASC [ RunTime:0.013133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17022916 LIMIT 5 [ RunTime:0.037505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17022916 ORDER BY `minOrder` ASC [ RunTime:0.030122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17022916 ORDER BY `unit` DESC [ RunTime:0.043247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17022916 LIMIT 2 [ RunTime:0.020873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17022916 ORDER BY `minOrder` ASC [ RunTime:0.010821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17022915 LIMIT 5 [ RunTime:0.003485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17022915 ORDER BY `minOrder` ASC [ RunTime:0.022045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17022915 ORDER BY `unit` DESC [ RunTime:0.029865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17022915 LIMIT 2 [ RunTime:0.016743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17022915 ORDER BY `minOrder` ASC [ RunTime:0.006137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15271292 LIMIT 5 [ RunTime:0.009753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15271292 ORDER BY `minOrder` ASC [ RunTime:0.019706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15271292 ORDER BY `unit` DESC [ RunTime:0.011111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15271292 LIMIT 2 [ RunTime:0.017320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15271292 ORDER BY `minOrder` ASC [ RunTime:0.008100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15271291 LIMIT 5 [ RunTime:0.035111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15271291 ORDER BY `minOrder` ASC [ RunTime:0.049570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15271291 ORDER BY `unit` DESC [ RunTime:0.022413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15271291 LIMIT 2 [ RunTime:0.006812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15271291 ORDER BY `minOrder` ASC [ RunTime:0.005017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15271290 LIMIT 5 [ RunTime:0.008181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15271290 ORDER BY `minOrder` ASC [ RunTime:0.019649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15271290 ORDER BY `unit` DESC [ RunTime:0.012989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15271290 LIMIT 2 [ RunTime:0.055758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15271290 ORDER BY `minOrder` ASC [ RunTime:0.003417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14200762 LIMIT 5 [ RunTime:0.026815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14200762 ORDER BY `minOrder` ASC [ RunTime:0.053866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14200762 ORDER BY `unit` DESC [ RunTime:0.027704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14200762 LIMIT 2 [ RunTime:0.078345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14200762 ORDER BY `minOrder` ASC [ RunTime:0.054168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14200699 LIMIT 5 [ RunTime:0.017012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14200699 ORDER BY `minOrder` ASC [ RunTime:0.086194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14200699 ORDER BY `unit` DESC [ RunTime:0.050576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14200699 LIMIT 2 [ RunTime:0.102109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14200699 ORDER BY `minOrder` ASC [ RunTime:0.035196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14200698 LIMIT 5 [ RunTime:0.042689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14200698 ORDER BY `minOrder` ASC [ RunTime:0.021302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14200698 ORDER BY `unit` DESC [ RunTime:0.010179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14200698 LIMIT 2 [ RunTime:0.066445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14200698 ORDER BY `minOrder` ASC [ RunTime:0.016979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543953 LIMIT 5 [ RunTime:0.113714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543953 ORDER BY `minOrder` ASC [ RunTime:0.077879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13543953 ORDER BY `unit` DESC [ RunTime:0.021926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13543953 LIMIT 2 [ RunTime:0.051209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543953 ORDER BY `minOrder` ASC [ RunTime:0.012035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543894 LIMIT 5 [ RunTime:0.025675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543894 ORDER BY `minOrder` ASC [ RunTime:0.074914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13543894 ORDER BY `unit` DESC [ RunTime:0.012033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13543894 LIMIT 2 [ RunTime:0.021932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543894 ORDER BY `minOrder` ASC [ RunTime:0.001433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13299868 LIMIT 5 [ RunTime:0.019905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13299868 ORDER BY `minOrder` ASC [ RunTime:0.023337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13299868 ORDER BY `unit` DESC [ RunTime:0.008520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13299868 LIMIT 2 [ RunTime:0.025245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13299868 ORDER BY `minOrder` ASC [ RunTime:0.002799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13299867 LIMIT 5 [ RunTime:0.012149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13299867 ORDER BY `minOrder` ASC [ RunTime:0.028708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13299867 ORDER BY `unit` DESC [ RunTime:0.027792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13299867 LIMIT 2 [ RunTime:0.012212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13299867 ORDER BY `minOrder` ASC [ RunTime:0.009568s ]
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 '21120%' OR `brand` LIKE '21120%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32309848 LIMIT 5 [ RunTime:0.015802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309848 ORDER BY `minOrder` ASC [ RunTime:0.041254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32309848 ORDER BY `unit` DESC [ RunTime:0.041174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32309848 LIMIT 2 [ RunTime:0.015702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309848 ORDER BY `minOrder` ASC [ RunTime:0.017282s ]
select * from pdf where partno='21120e-00-01-01' and brandshort='ecount embedded' limit 1 [ RunTime:0.029531s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120e-00-01-01' OR `brand` LIKE 'ecount embedded%' ) ) LIMIT 1 [ RunTime:0.018243s ]
SELECT `id` FROM `stock` WHERE `id` <> 32309848 AND `partno` = '21120e-00-01-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ecount embedded%' ) [ RunTime:0.021922s ]
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 '21120%' OR `brand` LIKE '21120%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361881 LIMIT 5 [ RunTime:0.042132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361881 ORDER BY `minOrder` ASC [ RunTime:0.032382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361881 ORDER BY `unit` DESC [ RunTime:0.005363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361881 LIMIT 2 [ RunTime:0.094829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361881 ORDER BY `minOrder` ASC [ RunTime:0.022774s ]
select * from pdf where partno='2112045-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.047105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2112045-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.020544s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361881 AND `partno` = '2112045-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.033559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613739 [ RunTime:0.026275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59941795 LIMIT 5 [ RunTime:0.012351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941795 ORDER BY `minOrder` ASC [ RunTime:0.078441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59941795 ORDER BY `unit` DESC [ RunTime:0.072655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59941795 LIMIT 2 [ RunTime:0.032990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941795 ORDER BY `minOrder` ASC [ RunTime:0.026128s ]
select * from pdf where partno='2112058-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.059097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2112058-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019381s ]
SELECT `id` FROM `stock` WHERE `id` <> 59941795 AND `partno` = '2112058-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616534 [ RunTime:0.013810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60364568 LIMIT 5 [ RunTime:0.040304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60364568 ORDER BY `minOrder` ASC [ RunTime:0.048997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60364568 ORDER BY `unit` DESC [ RunTime:0.035352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60364568 LIMIT 2 [ RunTime:0.021764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60364568 ORDER BY `minOrder` ASC [ RunTime:0.005804s ]
select * from pdf where partno='2112045-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.051988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2112045-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.024190s ]
SELECT `id` FROM `stock` WHERE `id` <> 60364568 AND `partno` = '2112045-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.039891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612993 [ RunTime:0.027574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63475801 LIMIT 5 [ RunTime:0.025359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63475801 ORDER BY `minOrder` ASC [ RunTime:0.014428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63475801 ORDER BY `unit` DESC [ RunTime:0.029443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63475801 LIMIT 2 [ RunTime:0.031889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63475801 ORDER BY `minOrder` ASC [ RunTime:0.041749s ]
select * from pdf where partno='21120132' and brandshort='Schroff' limit 1 [ RunTime:0.013304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120132' OR `brand` LIKE 'Schroff%' ) ) LIMIT 1 [ RunTime:0.007145s ]
SELECT `id` FROM `stock` WHERE `id` <> 63475801 AND `partno` = '21120132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schroff%' ) [ RunTime:0.053295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19009865 [ RunTime:0.022096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63470971 LIMIT 5 [ RunTime:0.023081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470971 ORDER BY `minOrder` ASC [ RunTime:0.049213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63470971 ORDER BY `unit` DESC [ RunTime:0.047329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63470971 LIMIT 2 [ RunTime:0.029463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470971 ORDER BY `minOrder` ASC [ RunTime:0.003850s ]
select * from pdf where partno='21120160' and brandshort='Schroff' limit 1 [ RunTime:0.010152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120160' OR `brand` LIKE 'Schroff%' ) ) LIMIT 1 [ RunTime:0.023993s ]
SELECT `id` FROM `stock` WHERE `id` <> 63470971 AND `partno` = '21120160' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schroff%' ) [ RunTime:0.067734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14200762 [ RunTime:0.020026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63470562 LIMIT 5 [ RunTime:0.008533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470562 ORDER BY `minOrder` ASC [ RunTime:0.021307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63470562 ORDER BY `unit` DESC [ RunTime:0.007554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63470562 LIMIT 2 [ RunTime:0.021189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470562 ORDER BY `minOrder` ASC [ RunTime:0.023881s ]
select * from pdf where partno='21120158' and brandshort='Schroff' limit 1 [ RunTime:0.015088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120158' OR `brand` LIKE 'Schroff%' ) ) LIMIT 1 [ RunTime:0.012442s ]
SELECT `id` FROM `stock` WHERE `id` <> 63470562 AND `partno` = '21120158' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schroff%' ) [ RunTime:0.012104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14200698 [ RunTime:0.008731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63470520 LIMIT 5 [ RunTime:0.030191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470520 ORDER BY `minOrder` ASC [ RunTime:0.042501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63470520 ORDER BY `unit` DESC [ RunTime:0.029159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63470520 LIMIT 2 [ RunTime:0.001869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470520 ORDER BY `minOrder` ASC [ RunTime:0.009913s ]
select * from pdf where partno='21120159' and brandshort='Schroff' limit 1 [ RunTime:0.008567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120159' OR `brand` LIKE 'Schroff%' ) ) LIMIT 1 [ RunTime:0.037861s ]
SELECT `id` FROM `stock` WHERE `id` <> 63470520 AND `partno` = '21120159' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schroff%' ) [ RunTime:0.064973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15271292 [ RunTime:0.021165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63470519 LIMIT 5 [ RunTime:0.056472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470519 ORDER BY `minOrder` ASC [ RunTime:0.029243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63470519 ORDER BY `unit` DESC [ RunTime:0.041980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63470519 LIMIT 2 [ RunTime:0.039147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470519 ORDER BY `minOrder` ASC [ RunTime:0.013838s ]
select * from pdf where partno='21120162' and brandshort='Schroff' limit 1 [ RunTime:0.001807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120162' OR `brand` LIKE 'Schroff%' ) ) LIMIT 1 [ RunTime:0.019844s ]
SELECT `id` FROM `stock` WHERE `id` <> 63470519 AND `partno` = '21120162' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schroff%' ) [ RunTime:0.021188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15271291 [ RunTime:0.018096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63470518 LIMIT 5 [ RunTime:0.015764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470518 ORDER BY `minOrder` ASC [ RunTime:0.000833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63470518 ORDER BY `unit` DESC [ RunTime:0.006418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63470518 LIMIT 2 [ RunTime:0.032184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470518 ORDER BY `minOrder` ASC [ RunTime:0.012368s ]
select * from pdf where partno='21120163' and brandshort='Schroff' limit 1 [ RunTime:0.012887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120163' OR `brand` LIKE 'Schroff%' ) ) LIMIT 1 [ RunTime:0.001792s ]
SELECT `id` FROM `stock` WHERE `id` <> 63470518 AND `partno` = '21120163' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schroff%' ) [ RunTime:0.004507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15271290 [ RunTime:0.024711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63470517 LIMIT 5 [ RunTime:0.021310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470517 ORDER BY `minOrder` ASC [ RunTime:0.006164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63470517 ORDER BY `unit` DESC [ RunTime:0.006909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63470517 LIMIT 2 [ RunTime:0.008133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470517 ORDER BY `minOrder` ASC [ RunTime:0.013530s ]
select * from pdf where partno='21120166' and brandshort='Schroff' limit 1 [ RunTime:0.000820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120166' OR `brand` LIKE 'Schroff%' ) ) LIMIT 1 [ RunTime:0.031047s ]
SELECT `id` FROM `stock` WHERE `id` <> 63470517 AND `partno` = '21120166' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schroff%' ) [ RunTime:0.002003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14200699 [ RunTime:0.001559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63470516 LIMIT 5 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470516 ORDER BY `minOrder` ASC [ RunTime:0.009387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63470516 ORDER BY `unit` DESC [ RunTime:0.009141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63470516 LIMIT 2 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63470516 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='21120161' and brandshort='Schroff' limit 1 [ RunTime:0.004132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120161' OR `brand` LIKE 'Schroff%' ) ) LIMIT 1 [ RunTime:0.003011s ]
SELECT `id` FROM `stock` WHERE `id` <> 63470516 AND `partno` = '21120161' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schroff%' ) [ RunTime:0.002448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19006016 [ RunTime:0.002962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150616 LIMIT 5 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150616 ORDER BY `minOrder` ASC [ RunTime:0.005599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150616 ORDER BY `unit` DESC [ RunTime:0.001905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150616 LIMIT 2 [ RunTime:0.006174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150616 ORDER BY `minOrder` ASC [ RunTime:0.008459s ]
select * from pdf where partno='21120.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.002924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.013195s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150616 AND `partno` = '21120.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.005046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543953 [ RunTime:0.003501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150465 LIMIT 5 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150465 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150465 ORDER BY `unit` DESC [ RunTime:0.003876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150465 LIMIT 2 [ RunTime:0.002519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150465 ORDER BY `minOrder` ASC [ RunTime:0.001915s ]
select * from pdf where partno='21120.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.001379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21120.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.007927s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150465 AND `partno` = '21120.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.005789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543894 [ RunTime:0.003632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60364578 LIMIT 5 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60364578 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60364578 ORDER BY `unit` DESC [ RunTime:0.001850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60364578 LIMIT 2 [ RunTime:0.002605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60364578 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
select * from pdf where partno='2112046-2' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.001207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2112046-2' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.002459s ]
SELECT `id` FROM `stock` WHERE `id` <> 60364578 AND `partno` = '2112046-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.000562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60363622 LIMIT 5 [ RunTime:0.001901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60363622 ORDER BY `minOrder` ASC [ RunTime:0.006163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60363622 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60363622 LIMIT 2 [ RunTime:0.005196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60363622 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='2112045-3' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2112045-3' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.001822s ]
SELECT `id` FROM `stock` WHERE `id` <> 60363622 AND `partno` = '2112045-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.004574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361939 LIMIT 5 [ RunTime:0.002453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361939 ORDER BY `minOrder` ASC [ RunTime:0.006782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361939 ORDER BY `unit` DESC [ RunTime:0.000929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361939 LIMIT 2 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361939 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
select * from pdf where partno='2112046-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2112046-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.004912s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361939 AND `partno` = '2112046-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.011028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616105 [ RunTime:0.000803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60349017 LIMIT 5 [ RunTime:0.003653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60349017 ORDER BY `minOrder` ASC [ RunTime:0.009483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60349017 ORDER BY `unit` DESC [ RunTime:0.000667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60349017 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60349017 ORDER BY `minOrder` ASC [ RunTime:0.001639s ]
select * from pdf where partno='2112027-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.012466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2112027-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.001654s ]
SELECT `id` FROM `stock` WHERE `id` <> 60349017 AND `partno` = '2112027-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482880 [ RunTime:0.006085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60348595 LIMIT 5 [ RunTime:0.002086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60348595 ORDER BY `minOrder` ASC [ RunTime:0.003692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60348595 ORDER BY `unit` DESC [ RunTime:0.003504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60348595 LIMIT 2 [ RunTime:0.002129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60348595 ORDER BY `minOrder` ASC [ RunTime:0.004213s ]
select * from pdf where partno='2112028-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.007840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2112028-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.004599s ]
SELECT `id` FROM `stock` WHERE `id` <> 60348595 AND `partno` = '2112028-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.004006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482756 [ RunTime:0.001049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59961561 LIMIT 5 [ RunTime:0.001430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59961561 ORDER BY `minOrder` ASC [ RunTime:0.002700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59961561 ORDER BY `unit` DESC [ RunTime:0.009100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59961561 LIMIT 2 [ RunTime:0.004029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59961561 ORDER BY `minOrder` ASC [ RunTime:0.002523s ]
select * from pdf where partno='2112058-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2112058-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001073s ]
SELECT `id` FROM `stock` WHERE `id` <> 59961561 AND `partno` = '2112058-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11491388 [ RunTime:0.006387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59960093 LIMIT 5 [ RunTime:0.001822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59960093 ORDER BY `minOrder` ASC [ RunTime:0.002566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59960093 ORDER BY `unit` DESC [ RunTime:0.001226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59960093 LIMIT 2 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59960093 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='2112058-5' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2112058-5' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.009077s ]
SELECT `id` FROM `stock` WHERE `id` <> 59960093 AND `partno` = '2112058-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.006810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12623303 [ RunTime:0.002380s ]
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 '21120%' OR `brand` LIKE '21120%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000780s ]
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 '21120%' OR `brand` LIKE '21120%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002038s ]
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 '21120%' OR `brand` LIKE '21120%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001593s ]
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 '21120%' OR `brand` LIKE '21120%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001223s ]
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 '21120%' OR `brand` LIKE '21120%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003520s ]
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 '21120%' OR `brand` LIKE '21120%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002455s ]
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 '21120%' OR `brand` LIKE '21120%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002499s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21120%' OR `brand` LIKE '21120%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004543s ]