SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001348s ]
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=7141&search=1' [ RunTime:0.009975s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001556s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.023687s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001604s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.004367s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001691s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014481s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002585s ]
SELECT * FROM `stock_search` WHERE `partno` = '7141' LIMIT 1 [ RunTime:0.061177s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-19 13:43:06' WHERE `partno` = '7141' [ RunTime:0.018247s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003634s ]
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 '7141%' OR `brand` LIKE '7141%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062364s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350694 LIMIT 5 [ RunTime:0.019197s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350694 ORDER BY `minOrder` ASC [ RunTime:0.016071s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350694 ORDER BY `unit` DESC [ RunTime:0.008959s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350694 LIMIT 2 [ RunTime:0.022602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350694 ORDER BY `minOrder` ASC [ RunTime:0.002020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351097 LIMIT 5 [ RunTime:0.006144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351097 ORDER BY `minOrder` ASC [ RunTime:0.018694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13351097 ORDER BY `unit` DESC [ RunTime:0.007888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13351097 LIMIT 2 [ RunTime:0.018405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351097 ORDER BY `minOrder` ASC [ RunTime:0.010831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350696 LIMIT 5 [ RunTime:0.061015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350696 ORDER BY `minOrder` ASC [ RunTime:0.010438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350696 ORDER BY `unit` DESC [ RunTime:0.048531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350696 LIMIT 2 [ RunTime:0.031841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350696 ORDER BY `minOrder` ASC [ RunTime:0.007903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18649800 LIMIT 5 [ RunTime:0.019146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18649800 ORDER BY `minOrder` ASC [ RunTime:0.012035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18649800 ORDER BY `unit` DESC [ RunTime:0.011730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18649800 LIMIT 2 [ RunTime:0.020455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18649800 ORDER BY `minOrder` ASC [ RunTime:0.003148s ]
select * from pdf where partno='7141DG' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.033074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068158 LIMIT 5 [ RunTime:0.031821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068158 ORDER BY `minOrder` ASC [ RunTime:0.042818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068158 ORDER BY `unit` DESC [ RunTime:0.017755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068158 LIMIT 2 [ RunTime:0.012341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068158 ORDER BY `minOrder` ASC [ RunTime:0.005471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067601 LIMIT 5 [ RunTime:0.019270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067601 ORDER BY `minOrder` ASC [ RunTime:0.005843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067601 ORDER BY `unit` DESC [ RunTime:0.016401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067601 LIMIT 2 [ RunTime:0.044715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067601 ORDER BY `minOrder` ASC [ RunTime:0.026024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068160 LIMIT 5 [ RunTime:0.023013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068160 ORDER BY `minOrder` ASC [ RunTime:0.018066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068160 ORDER BY `unit` DESC [ RunTime:0.021862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068160 LIMIT 2 [ RunTime:0.003984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068160 ORDER BY `minOrder` ASC [ RunTime:0.009065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067603 LIMIT 5 [ RunTime:0.007895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067603 ORDER BY `minOrder` ASC [ RunTime:0.006390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067603 ORDER BY `unit` DESC [ RunTime:0.018600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067603 LIMIT 2 [ RunTime:0.003824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067603 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068162 LIMIT 5 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068162 ORDER BY `minOrder` ASC [ RunTime:0.002996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068162 ORDER BY `unit` DESC [ RunTime:0.021771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068162 LIMIT 2 [ RunTime:0.016889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068162 ORDER BY `minOrder` ASC [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067872 LIMIT 5 [ RunTime:0.001024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067872 ORDER BY `minOrder` ASC [ RunTime:0.003353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067872 ORDER BY `unit` DESC [ RunTime:0.009290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067872 LIMIT 2 [ RunTime:0.014387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067872 ORDER BY `minOrder` ASC [ RunTime:0.001995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068163 LIMIT 5 [ RunTime:0.010351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068163 ORDER BY `minOrder` ASC [ RunTime:0.004000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068163 ORDER BY `unit` DESC [ RunTime:0.000878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068163 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068163 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349792 LIMIT 5 [ RunTime:0.001149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349792 ORDER BY `minOrder` ASC [ RunTime:0.024934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349792 ORDER BY `unit` DESC [ RunTime:0.051125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349792 LIMIT 2 [ RunTime:0.026588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349792 ORDER BY `minOrder` ASC [ RunTime:0.017928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068268 LIMIT 5 [ RunTime:0.024866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068268 ORDER BY `minOrder` ASC [ RunTime:0.015635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068268 ORDER BY `unit` DESC [ RunTime:0.005237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068268 LIMIT 2 [ RunTime:0.007886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068268 ORDER BY `minOrder` ASC [ RunTime:0.071703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351106 LIMIT 5 [ RunTime:0.017711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351106 ORDER BY `minOrder` ASC [ RunTime:0.071587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13351106 ORDER BY `unit` DESC [ RunTime:0.062460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13351106 LIMIT 2 [ RunTime:0.069564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351106 ORDER BY `minOrder` ASC [ RunTime:0.034343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068164 LIMIT 5 [ RunTime:0.023020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068164 ORDER BY `minOrder` ASC [ RunTime:0.046741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068164 ORDER BY `unit` DESC [ RunTime:0.049826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068164 LIMIT 2 [ RunTime:0.002291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068164 ORDER BY `minOrder` ASC [ RunTime:0.023916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19269335 LIMIT 5 [ RunTime:0.022165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19269335 ORDER BY `minOrder` ASC [ RunTime:0.026213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19269335 ORDER BY `unit` DESC [ RunTime:0.022797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19269335 LIMIT 2 [ RunTime:0.039716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19269335 ORDER BY `minOrder` ASC [ RunTime:0.012173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067875 LIMIT 5 [ RunTime:0.023466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067875 ORDER BY `minOrder` ASC [ RunTime:0.014653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067875 ORDER BY `unit` DESC [ RunTime:0.003836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067875 LIMIT 2 [ RunTime:0.019251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067875 ORDER BY `minOrder` ASC [ RunTime:0.007445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19020786 LIMIT 5 [ RunTime:0.025906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19020786 ORDER BY `minOrder` ASC [ RunTime:0.014373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19020786 ORDER BY `unit` DESC [ RunTime:0.021583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19020786 LIMIT 2 [ RunTime:0.024412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19020786 ORDER BY `minOrder` ASC [ RunTime:0.012603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15361635 LIMIT 5 [ RunTime:0.030023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15361635 ORDER BY `minOrder` ASC [ RunTime:0.019835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15361635 ORDER BY `unit` DESC [ RunTime:0.042241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15361635 LIMIT 2 [ RunTime:0.004887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15361635 ORDER BY `minOrder` ASC [ RunTime:0.019495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705732 LIMIT 5 [ RunTime:0.024126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705732 ORDER BY `minOrder` ASC [ RunTime:0.023173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18705732 ORDER BY `unit` DESC [ RunTime:0.032043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18705732 LIMIT 2 [ RunTime:0.016041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705732 ORDER BY `minOrder` ASC [ RunTime:0.019281s ]
select * from pdf where partno='7141E' and brandshort='Excelta Corporation' limit 1 [ RunTime:0.077132s ]
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 '7141%' OR `brand` LIKE '7141%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009134s ]
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 '7141%' OR `brand` LIKE '7141%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561751 LIMIT 5 [ RunTime:0.002798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561751 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561751 ORDER BY `unit` DESC [ RunTime:0.002625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561751 LIMIT 2 [ RunTime:0.014953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561751 ORDER BY `minOrder` ASC [ RunTime:0.004829s ]
select * from pdf where partno='71417CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006439s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71417CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.007885s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561751 AND `partno` = '71417CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.008168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067872 [ RunTime:0.005229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562632 LIMIT 5 [ RunTime:0.002951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562632 ORDER BY `minOrder` ASC [ RunTime:0.010782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562632 ORDER BY `unit` DESC [ RunTime:0.030888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562632 LIMIT 2 [ RunTime:0.015590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562632 ORDER BY `minOrder` ASC [ RunTime:0.006698s ]
select * from pdf where partno='71412SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.040228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71412SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013302s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562632 AND `partno` = '71412SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.006251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068268 [ RunTime:0.004852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43884967 LIMIT 5 [ RunTime:0.002066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884967 ORDER BY `minOrder` ASC [ RunTime:0.004274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43884967 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43884967 LIMIT 2 [ RunTime:0.002013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884967 ORDER BY `minOrder` ASC [ RunTime:0.001041s ]
select * from pdf where partno='7141DG' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.002776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7141DG' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.003843s ]
SELECT `id` FROM `stock` WHERE `id` <> 43884967 AND `partno` = '7141DG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.011270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18649800 [ RunTime:0.031660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561174 LIMIT 5 [ RunTime:0.014320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561174 ORDER BY `minOrder` ASC [ RunTime:0.019158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561174 ORDER BY `unit` DESC [ RunTime:0.014679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561174 LIMIT 2 [ RunTime:0.090318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561174 ORDER BY `minOrder` ASC [ RunTime:0.035470s ]
select * from pdf where partno='71412CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.017058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71412CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013239s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561174 AND `partno` = '71412CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.012113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067603 [ RunTime:0.016271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562449 LIMIT 5 [ RunTime:0.016078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562449 ORDER BY `minOrder` ASC [ RunTime:0.002407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562449 ORDER BY `unit` DESC [ RunTime:0.008429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562449 LIMIT 2 [ RunTime:0.011065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562449 ORDER BY `minOrder` ASC [ RunTime:0.001213s ]
select * from pdf where partno='71413SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71413SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010631s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562449 AND `partno` = '71413SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.017710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068164 [ RunTime:0.013431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561757 LIMIT 5 [ RunTime:0.015089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561757 ORDER BY `minOrder` ASC [ RunTime:0.035330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561757 ORDER BY `unit` DESC [ RunTime:0.050695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561757 LIMIT 2 [ RunTime:0.032910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561757 ORDER BY `minOrder` ASC [ RunTime:0.024179s ]
select * from pdf where partno='71415CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.020812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71415CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.006200s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561757 AND `partno` = '71415CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.012250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350696 [ RunTime:0.014901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560425 LIMIT 5 [ RunTime:0.011847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560425 ORDER BY `minOrder` ASC [ RunTime:0.008622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560425 ORDER BY `unit` DESC [ RunTime:0.003273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560425 LIMIT 2 [ RunTime:0.008138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560425 ORDER BY `minOrder` ASC [ RunTime:0.004766s ]
select * from pdf where partno='71414CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.011555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71414CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004782s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560425 AND `partno` = '71414CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.012373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349792 [ RunTime:0.025935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561764 LIMIT 5 [ RunTime:0.016351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561764 ORDER BY `minOrder` ASC [ RunTime:0.001276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561764 ORDER BY `unit` DESC [ RunTime:0.000643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561764 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561764 ORDER BY `minOrder` ASC [ RunTime:0.020768s ]
select * from pdf where partno='71416CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.005116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71416CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.021117s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561764 AND `partno` = '71416CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.026352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067875 [ RunTime:0.017828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562452 LIMIT 5 [ RunTime:0.018813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562452 ORDER BY `minOrder` ASC [ RunTime:0.016496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562452 ORDER BY `unit` DESC [ RunTime:0.040126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562452 LIMIT 2 [ RunTime:0.024626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562452 ORDER BY `minOrder` ASC [ RunTime:0.008936s ]
select * from pdf where partno='71417SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.041577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71417SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.045394s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562452 AND `partno` = '71417SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.035207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068158 [ RunTime:0.034092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562453 LIMIT 5 [ RunTime:0.021494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562453 ORDER BY `minOrder` ASC [ RunTime:0.024617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562453 ORDER BY `unit` DESC [ RunTime:0.017794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562453 LIMIT 2 [ RunTime:0.005840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562453 ORDER BY `minOrder` ASC [ RunTime:0.010982s ]
select * from pdf where partno='71411SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.034879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71411SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008255s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562453 AND `partno` = '71411SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.027911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068160 [ RunTime:0.014368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562456 LIMIT 5 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562456 ORDER BY `minOrder` ASC [ RunTime:0.006343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562456 ORDER BY `unit` DESC [ RunTime:0.027545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562456 LIMIT 2 [ RunTime:0.001040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562456 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='71418SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.022620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71418SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008409s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562456 AND `partno` = '71418SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068162 [ RunTime:0.001532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64466082 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64466082 ORDER BY `minOrder` ASC [ RunTime:0.002437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64466082 ORDER BY `unit` DESC [ RunTime:0.014304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64466082 LIMIT 2 [ RunTime:0.021002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64466082 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='7141-24-1100' and brandshort='Coto Technology' limit 1 [ RunTime:0.006094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7141-24-1100' OR `brand` LIKE 'Coto Technology%' ) ) LIMIT 1 [ RunTime:0.011558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562457 LIMIT 5 [ RunTime:0.017194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562457 ORDER BY `minOrder` ASC [ RunTime:0.017246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562457 ORDER BY `unit` DESC [ RunTime:0.007184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562457 LIMIT 2 [ RunTime:0.012104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562457 ORDER BY `minOrder` ASC [ RunTime:0.004962s ]
select * from pdf where partno='71419SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.005517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71419SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.007775s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562457 AND `partno` = '71419SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.027987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351097 [ RunTime:0.012983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63416829 LIMIT 5 [ RunTime:0.013953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63416829 ORDER BY `minOrder` ASC [ RunTime:0.030935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63416829 ORDER BY `unit` DESC [ RunTime:0.042882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63416829 LIMIT 2 [ RunTime:0.001908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63416829 ORDER BY `minOrder` ASC [ RunTime:0.000267s ]
select * from pdf where partno='7141' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.003012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7141' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001384s ]
SELECT `id` FROM `stock` WHERE `id` <> 63416829 AND `partno` = '7141' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19020786 [ RunTime:0.004335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64566103 LIMIT 5 [ RunTime:0.028401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566103 ORDER BY `minOrder` ASC [ RunTime:0.028634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64566103 ORDER BY `unit` DESC [ RunTime:0.032280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64566103 LIMIT 2 [ RunTime:0.029848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566103 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='71414SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71414SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004042s ]
SELECT `id` FROM `stock` WHERE `id` <> 64566103 AND `partno` = '71414SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.047589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351106 [ RunTime:0.055326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64565975 LIMIT 5 [ RunTime:0.010413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565975 ORDER BY `minOrder` ASC [ RunTime:0.022430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64565975 ORDER BY `unit` DESC [ RunTime:0.036758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64565975 LIMIT 2 [ RunTime:0.004325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565975 ORDER BY `minOrder` ASC [ RunTime:0.005151s ]
select * from pdf where partno='71419CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.012549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71419CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.022800s ]
SELECT `id` FROM `stock` WHERE `id` <> 64565975 AND `partno` = '71419CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.009425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350694 [ RunTime:0.022459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64566105 LIMIT 5 [ RunTime:0.029942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566105 ORDER BY `minOrder` ASC [ RunTime:0.015426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64566105 ORDER BY `unit` DESC [ RunTime:0.011425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64566105 LIMIT 2 [ RunTime:0.026415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566105 ORDER BY `minOrder` ASC [ RunTime:0.004000s ]
select * from pdf where partno='71416SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.008339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71416SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.005310s ]
SELECT `id` FROM `stock` WHERE `id` <> 64566105 AND `partno` = '71416SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.019650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068163 [ RunTime:0.008919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64565977 LIMIT 5 [ RunTime:0.004822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565977 ORDER BY `minOrder` ASC [ RunTime:0.035405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64565977 ORDER BY `unit` DESC [ RunTime:0.036187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64565977 LIMIT 2 [ RunTime:0.019669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565977 ORDER BY `minOrder` ASC [ RunTime:0.032490s ]
select * from pdf where partno='71418CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.022688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71418CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.068043s ]
SELECT `id` FROM `stock` WHERE `id` <> 64565977 AND `partno` = '71418CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.053395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64466175 LIMIT 5 [ RunTime:0.038182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64466175 ORDER BY `minOrder` ASC [ RunTime:0.065114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64466175 ORDER BY `unit` DESC [ RunTime:0.064996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64466175 LIMIT 2 [ RunTime:0.032306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64466175 ORDER BY `minOrder` ASC [ RunTime:0.051318s ]
select * from pdf where partno='7141-12-1001' and brandshort='Coto Technology' limit 1 [ RunTime:0.070020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7141-12-1001' OR `brand` LIKE 'Coto Technology%' ) ) LIMIT 1 [ RunTime:0.044038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64566814 LIMIT 5 [ RunTime:0.035037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566814 ORDER BY `minOrder` ASC [ RunTime:0.020238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64566814 ORDER BY `unit` DESC [ RunTime:0.011790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64566814 LIMIT 2 [ RunTime:0.005285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566814 ORDER BY `minOrder` ASC [ RunTime:0.012769s ]
select * from pdf where partno='71411CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.071834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71411CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.020980s ]
SELECT `id` FROM `stock` WHERE `id` <> 64566814 AND `partno` = '71411CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.024143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067601 [ RunTime:0.010634s ]
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 '7141%' OR `brand` LIKE '7141%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012411s ]
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 '7141%' OR `brand` LIKE '7141%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008796s ]
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 '7141%' OR `brand` LIKE '7141%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014538s ]
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 '7141%' OR `brand` LIKE '7141%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003310s ]
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 '7141%' OR `brand` LIKE '7141%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001114s ]
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 '7141%' OR `brand` LIKE '7141%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027678s ]
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 '7141%' OR `brand` LIKE '7141%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001209s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7141%' OR `brand` LIKE '7141%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013419s ]