SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001191s ]
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=T491A105K035AT&search=1' [ RunTime:0.005483s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001582s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002253s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001514s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.003541s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003110s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001135s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002426s ]
SELECT * FROM `stock_search` WHERE `partno` = 'T491A105K035AT' LIMIT 1 [ RunTime:0.006689s ]
UPDATE `stock_search` SET `count` = 12279 , `updatetime` = '2026-08-18 23:36:06' WHERE `partno` = 'T491A105K035AT' [ RunTime:0.022503s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002792s ]
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 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014063s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14926346 LIMIT 5 [ RunTime:0.015060s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14926346 ORDER BY `minOrder` ASC [ RunTime:0.026191s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14926346 ORDER BY `unit` DESC [ RunTime:0.042803s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14926346 LIMIT 2 [ RunTime:0.016196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14926346 ORDER BY `minOrder` ASC [ RunTime:0.012062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14922283 LIMIT 5 [ RunTime:0.036138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14922283 ORDER BY `minOrder` ASC [ RunTime:0.030098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14922283 ORDER BY `unit` DESC [ RunTime:0.042311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14922283 LIMIT 2 [ RunTime:0.014051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14922283 ORDER BY `minOrder` ASC [ RunTime:0.040064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15602976 LIMIT 5 [ RunTime:0.021349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15602976 ORDER BY `minOrder` ASC [ RunTime:0.013181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15602976 ORDER BY `unit` DESC [ RunTime:0.029260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15602976 LIMIT 2 [ RunTime:0.053342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15602976 ORDER BY `minOrder` ASC [ RunTime:0.014777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2036 LIMIT 5 [ RunTime:0.072907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2036 ORDER BY `minOrder` ASC [ RunTime:0.070316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2036 ORDER BY `unit` DESC [ RunTime:0.033691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2036 LIMIT 2 [ RunTime:0.012889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2036 ORDER BY `minOrder` ASC [ RunTime:0.005246s ]
select * from pdf where partno='T491A105K035AT' and brandshort='KEMET' limit 1 [ RunTime:0.030602s ]
select foldpath,foldpath2,filename from pdf_file where id=610752 limit 1 [ RunTime:0.016269s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491A105K035AT' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.012038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17663136 LIMIT 5 [ RunTime:0.019401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17663136 ORDER BY `minOrder` ASC [ RunTime:0.004532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17663136 ORDER BY `unit` DESC [ RunTime:0.048535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17663136 LIMIT 2 [ RunTime:0.016215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17663136 ORDER BY `minOrder` ASC [ RunTime:0.024353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17663135 LIMIT 5 [ RunTime:0.013056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17663135 ORDER BY `minOrder` ASC [ RunTime:0.021855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17663135 ORDER BY `unit` DESC [ RunTime:0.011565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17663135 LIMIT 2 [ RunTime:0.055319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17663135 ORDER BY `minOrder` ASC [ RunTime:0.001702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17623883 LIMIT 5 [ RunTime:0.050822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17623883 ORDER BY `minOrder` ASC [ RunTime:0.022480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17623883 ORDER BY `unit` DESC [ RunTime:0.013501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17623883 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17623883 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17621624 LIMIT 5 [ RunTime:0.012980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17621624 ORDER BY `minOrder` ASC [ RunTime:0.027784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17621624 ORDER BY `unit` DESC [ RunTime:0.017591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17621624 LIMIT 2 [ RunTime:0.014395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17621624 ORDER BY `minOrder` ASC [ RunTime:0.008573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17619480 LIMIT 5 [ RunTime:0.021846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17619480 ORDER BY `minOrder` ASC [ RunTime:0.015262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17619480 ORDER BY `unit` DESC [ RunTime:0.022669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17619480 LIMIT 2 [ RunTime:0.014854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17619480 ORDER BY `minOrder` ASC [ RunTime:0.000956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15624160 LIMIT 5 [ RunTime:0.004607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15624160 ORDER BY `minOrder` ASC [ RunTime:0.004454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15624160 ORDER BY `unit` DESC [ RunTime:0.017541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15624160 LIMIT 2 [ RunTime:0.014240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15624160 ORDER BY `minOrder` ASC [ RunTime:0.005334s ]
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 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005414s ]
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 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39316278 LIMIT 5 [ RunTime:0.013610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39316278 ORDER BY `minOrder` ASC [ RunTime:0.022242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39316278 ORDER BY `unit` DESC [ RunTime:0.000780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39316278 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39316278 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='T491A105K035AT' and brandshort='KEMET' limit 1 [ RunTime:0.000598s ]
select foldpath,foldpath2,filename from pdf_file where id=610752 limit 1 [ RunTime:0.005091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491A105K035AT' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39319311 LIMIT 5 [ RunTime:0.007671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39319311 ORDER BY `minOrder` ASC [ RunTime:0.012755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39319311 ORDER BY `unit` DESC [ RunTime:0.010400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39319311 LIMIT 2 [ RunTime:0.012233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39319311 ORDER BY `minOrder` ASC [ RunTime:0.008376s ]
select * from pdf where partno='T491A105K035AT7280' and brandshort='KEMET' limit 1 [ RunTime:0.008404s ]
select foldpath,foldpath2,filename from pdf_file where id=1635203 limit 1 [ RunTime:0.012491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491A105K035AT7280' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.005135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39317705 LIMIT 5 [ RunTime:0.011746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39317705 ORDER BY `minOrder` ASC [ RunTime:0.015838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39317705 ORDER BY `unit` DESC [ RunTime:0.009678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39317705 LIMIT 2 [ RunTime:0.004428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39317705 ORDER BY `minOrder` ASC [ RunTime:0.006523s ]
select * from pdf where partno='T491A105K035ATAUTO' and brandshort='KEMET' limit 1 [ RunTime:0.005522s ]
select foldpath,foldpath2,filename from pdf_file where id=1635560 limit 1 [ RunTime:0.002962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491A105K035ATAUTO' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.012059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39328693 LIMIT 5 [ RunTime:0.006818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39328693 ORDER BY `minOrder` ASC [ RunTime:0.008692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39328693 ORDER BY `unit` DESC [ RunTime:0.026562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39328693 LIMIT 2 [ RunTime:0.008336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39328693 ORDER BY `minOrder` ASC [ RunTime:0.003177s ]
select * from pdf where partno='T491A105K035AT2478' and brandshort='KEMET' limit 1 [ RunTime:0.012553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491A105K035AT2478' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.014331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39326915 LIMIT 5 [ RunTime:0.000802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39326915 ORDER BY `minOrder` ASC [ RunTime:0.016613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39326915 ORDER BY `unit` DESC [ RunTime:0.033749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39326915 LIMIT 2 [ RunTime:0.008246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39326915 ORDER BY `minOrder` ASC [ RunTime:0.002150s ]
select * from pdf where partno='T491A105K035AT4021' and brandshort='KEMET' limit 1 [ RunTime:0.007071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491A105K035AT4021' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.015465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39326442 LIMIT 5 [ RunTime:0.005046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39326442 ORDER BY `minOrder` ASC [ RunTime:0.008745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39326442 ORDER BY `unit` DESC [ RunTime:0.025571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39326442 LIMIT 2 [ RunTime:0.008771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39326442 ORDER BY `minOrder` ASC [ RunTime:0.009569s ]
select * from pdf where partno='T491A105K035AT4380' and brandshort='KEMET' limit 1 [ RunTime:0.009867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491A105K035AT4380' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.053567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39326244 LIMIT 5 [ RunTime:0.002549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39326244 ORDER BY `minOrder` ASC [ RunTime:0.001557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39326244 ORDER BY `unit` DESC [ RunTime:0.028672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39326244 LIMIT 2 [ RunTime:0.038633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39326244 ORDER BY `minOrder` ASC [ RunTime:0.000570s ]
select * from pdf where partno='T491A105K035AT4860' and brandshort='KEMET' limit 1 [ RunTime:0.030845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491A105K035AT4860' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.027178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39326243 LIMIT 5 [ RunTime:0.012986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39326243 ORDER BY `minOrder` ASC [ RunTime:0.010073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39326243 ORDER BY `unit` DESC [ RunTime:0.007266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39326243 LIMIT 2 [ RunTime:0.025606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39326243 ORDER BY `minOrder` ASC [ RunTime:0.008191s ]
select * from pdf where partno='T491A105K035AT4539' and brandshort='KEMET' limit 1 [ RunTime:0.029116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491A105K035AT4539' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.034601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39326242 LIMIT 5 [ RunTime:0.020332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39326242 ORDER BY `minOrder` ASC [ RunTime:0.016024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39326242 ORDER BY `unit` DESC [ RunTime:0.018599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39326242 LIMIT 2 [ RunTime:0.033188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39326242 ORDER BY `minOrder` ASC [ RunTime:0.023921s ]
select * from pdf where partno='T491A105K035AT4280' and brandshort='KEMET' limit 1 [ RunTime:0.023767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491A105K035AT4280' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.023824s ]
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 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018434s ]
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 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044787s ]
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 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028859s ]
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 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025717s ]
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 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011583s ]
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 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017130s ]
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 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024770s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'T491A105K035AT%' OR `brand` LIKE 'T491A105K035AT%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016064s ]