SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001944s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `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=mr-3&search=1' [ RunTime:0.008288s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002410s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003246s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001887s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.003437s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001344s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010181s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001398s ]
SELECT * FROM `stock_search` WHERE `partno` = 'mr-3' LIMIT 1 [ RunTime:0.032600s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-28 22:56:12' WHERE `partno` = 'mr-3' [ RunTime:0.007754s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001646s ]
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 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027010s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12869628 LIMIT 5 [ RunTime:0.009773s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12869628 ORDER BY `minOrder` ASC [ RunTime:0.018644s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12869628 ORDER BY `unit` DESC [ RunTime:0.041712s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12869628 LIMIT 2 [ RunTime:0.023354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12869628 ORDER BY `minOrder` ASC [ RunTime:0.027863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12870686 LIMIT 5 [ RunTime:0.079675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12870686 ORDER BY `minOrder` ASC [ RunTime:0.028056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12870686 ORDER BY `unit` DESC [ RunTime:0.045223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12870686 LIMIT 2 [ RunTime:0.023810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12870686 ORDER BY `minOrder` ASC [ RunTime:0.052650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11675446 LIMIT 5 [ RunTime:0.039836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11675446 ORDER BY `minOrder` ASC [ RunTime:0.116448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11675446 ORDER BY `unit` DESC [ RunTime:0.034964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11675446 LIMIT 2 [ RunTime:0.175285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11675446 ORDER BY `minOrder` ASC [ RunTime:0.053307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12870805 LIMIT 5 [ RunTime:0.109862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12870805 ORDER BY `minOrder` ASC [ RunTime:0.173677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12870805 ORDER BY `unit` DESC [ RunTime:0.193722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12870805 LIMIT 2 [ RunTime:0.016128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12870805 ORDER BY `minOrder` ASC [ RunTime:0.072069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12254102 LIMIT 5 [ RunTime:0.094694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12254102 ORDER BY `minOrder` ASC [ RunTime:0.065852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12254102 ORDER BY `unit` DESC [ RunTime:0.010158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12254102 LIMIT 2 [ RunTime:0.028906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12254102 ORDER BY `minOrder` ASC [ RunTime:0.042266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13362003 LIMIT 5 [ RunTime:0.051682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13362003 ORDER BY `minOrder` ASC [ RunTime:0.043595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13362003 ORDER BY `unit` DESC [ RunTime:0.064501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13362003 LIMIT 2 [ RunTime:0.035559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13362003 ORDER BY `minOrder` ASC [ RunTime:0.011676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870902 LIMIT 5 [ RunTime:0.143103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870902 ORDER BY `minOrder` ASC [ RunTime:0.037553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11870902 ORDER BY `unit` DESC [ RunTime:0.082935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11870902 LIMIT 2 [ RunTime:0.056304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870902 ORDER BY `minOrder` ASC [ RunTime:0.010868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870732 LIMIT 5 [ RunTime:0.033976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870732 ORDER BY `minOrder` ASC [ RunTime:0.028898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11870732 ORDER BY `unit` DESC [ RunTime:0.045322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11870732 LIMIT 2 [ RunTime:0.059693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11870732 ORDER BY `minOrder` ASC [ RunTime:0.032500s ]
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 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32271706 LIMIT 5 [ RunTime:0.074995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32271706 ORDER BY `minOrder` ASC [ RunTime:0.048014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32271706 ORDER BY `unit` DESC [ RunTime:0.121767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32271706 LIMIT 2 [ RunTime:0.119784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32271706 ORDER BY `minOrder` ASC [ RunTime:0.054458s ]
select * from pdf where partno='mr-3530' and brandshort='same sky' limit 1 [ RunTime:0.032607s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mr-3530' OR `brand` LIKE 'same sky%' ) ) LIMIT 1 [ RunTime:0.036144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32239305 LIMIT 5 [ RunTime:0.062273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239305 ORDER BY `minOrder` ASC [ RunTime:0.117657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32239305 ORDER BY `unit` DESC [ RunTime:0.076764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32239305 LIMIT 2 [ RunTime:0.110131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32239305 ORDER BY `minOrder` ASC [ RunTime:0.067957s ]
select * from pdf where partno='mr-3' and brandshort='kemet' limit 1 [ RunTime:0.048421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mr-3' OR `brand` LIKE 'kemet%' ) ) LIMIT 1 [ RunTime:0.058478s ]
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 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.084814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54185367 LIMIT 5 [ RunTime:0.011890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54185367 ORDER BY `minOrder` ASC [ RunTime:0.101056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54185367 ORDER BY `unit` DESC [ RunTime:0.071465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54185367 LIMIT 2 [ RunTime:0.040239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54185367 ORDER BY `minOrder` ASC [ RunTime:0.084307s ]
select * from pdf where partno='MR-3501' and brandshort='Same Sky Formerly CUI Devices' limit 1 [ RunTime:0.040385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR-3501' OR `brand` LIKE 'Same Sky (Formerly CUI Devices)%' ) ) LIMIT 1 [ RunTime:0.037264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54185721 LIMIT 5 [ RunTime:0.069752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54185721 ORDER BY `minOrder` ASC [ RunTime:0.062025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54185721 ORDER BY `unit` DESC [ RunTime:0.040630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54185721 LIMIT 2 [ RunTime:0.058418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54185721 ORDER BY `minOrder` ASC [ RunTime:0.052662s ]
select * from pdf where partno='MR-3530A' and brandshort='Same Sky Formerly CUI Devices' limit 1 [ RunTime:0.119003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR-3530A' OR `brand` LIKE 'Same Sky (Formerly CUI Devices)%' ) ) LIMIT 1 [ RunTime:0.109493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54185600 LIMIT 5 [ RunTime:0.035849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54185600 ORDER BY `minOrder` ASC [ RunTime:0.039817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54185600 ORDER BY `unit` DESC [ RunTime:0.100482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54185600 LIMIT 2 [ RunTime:0.055930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54185600 ORDER BY `minOrder` ASC [ RunTime:0.051479s ]
select * from pdf where partno='MR-3530' and brandshort='Same Sky Formerly CUI Devices' limit 1 [ RunTime:0.052015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR-3530' OR `brand` LIKE 'Same Sky (Formerly CUI Devices)%' ) ) LIMIT 1 [ RunTime:0.058901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54185914 LIMIT 5 [ RunTime:0.061719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54185914 ORDER BY `minOrder` ASC [ RunTime:0.121600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54185914 ORDER BY `unit` DESC [ RunTime:0.096448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54185914 LIMIT 2 [ RunTime:0.068635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54185914 ORDER BY `minOrder` ASC [ RunTime:0.065418s ]
select * from pdf where partno='MR-3502' and brandshort='Same Sky Formerly CUI Devices' limit 1 [ RunTime:0.036807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR-3502' OR `brand` LIKE 'Same Sky (Formerly CUI Devices)%' ) ) LIMIT 1 [ RunTime:0.022023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51374222 LIMIT 5 [ RunTime:0.105819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51374222 ORDER BY `minOrder` ASC [ RunTime:0.070387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51374222 ORDER BY `unit` DESC [ RunTime:0.029120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51374222 LIMIT 2 [ RunTime:0.022805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51374222 ORDER BY `minOrder` ASC [ RunTime:0.028553s ]
select * from pdf where partno='MR-3' and brandshort='KEMET' limit 1 [ RunTime:0.034577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR-3' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.078273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55295672 LIMIT 5 [ RunTime:0.066738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55295672 ORDER BY `minOrder` ASC [ RunTime:0.071510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55295672 ORDER BY `unit` DESC [ RunTime:0.026727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55295672 LIMIT 2 [ RunTime:0.033124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55295672 ORDER BY `minOrder` ASC [ RunTime:0.030669s ]
select * from pdf where partno='MR-361-051-435-220S-905' and brandshort='AirBorn, a Molex company' limit 1 [ RunTime:0.086783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR-361-051-435-220S-905' OR `brand` LIKE 'AirBorn, a Molex company%' ) ) LIMIT 1 [ RunTime:0.039762s ]
SELECT `id` FROM `stock` WHERE `id` <> 55295672 AND `partno` = 'MR-361-051-435-220S-905' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%airborn, a molex company%' ) [ RunTime:0.069463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11870902 [ RunTime:0.046376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55294543 LIMIT 5 [ RunTime:0.079355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55294543 ORDER BY `minOrder` ASC [ RunTime:0.015345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55294543 ORDER BY `unit` DESC [ RunTime:0.050983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55294543 LIMIT 2 [ RunTime:0.031646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55294543 ORDER BY `minOrder` ASC [ RunTime:0.056790s ]
select * from pdf where partno='MR-361-051-445-220S' and brandshort='Molex' limit 1 [ RunTime:0.051459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR-361-051-445-220S' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.046762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51372084 LIMIT 5 [ RunTime:0.084487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51372084 ORDER BY `minOrder` ASC [ RunTime:0.211633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51372084 ORDER BY `unit` DESC [ RunTime:0.125309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51372084 LIMIT 2 [ RunTime:0.140616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51372084 ORDER BY `minOrder` ASC [ RunTime:0.014153s ]
select * from pdf where partno='MR-33378-000' and brandshort='Knowles' limit 1 [ RunTime:0.084504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR-33378-000' OR `brand` LIKE 'Knowles%' ) ) LIMIT 1 [ RunTime:0.053131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32648415 LIMIT 5 [ RunTime:0.086378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32648415 ORDER BY `minOrder` ASC [ RunTime:0.084078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32648415 ORDER BY `unit` DESC [ RunTime:0.059852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32648415 LIMIT 2 [ RunTime:0.031072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32648415 ORDER BY `minOrder` ASC [ RunTime:0.033087s ]
select * from pdf where partno='MR-3D-110' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.053657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR-3D-110' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.041271s ]
SELECT `id` FROM `stock` WHERE `id` <> 32648415 AND `partno` = 'MR-3D-110' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.096959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32648332 LIMIT 5 [ RunTime:0.035278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32648332 ORDER BY `minOrder` ASC [ RunTime:0.062710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32648332 ORDER BY `unit` DESC [ RunTime:0.073118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32648332 LIMIT 2 [ RunTime:0.029393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32648332 ORDER BY `minOrder` ASC [ RunTime:0.017934s ]
select * from pdf where partno='MR-3A-120' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.023130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR-3A-120' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.081321s ]
SELECT `id` FROM `stock` WHERE `id` <> 32648332 AND `partno` = 'MR-3A-120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.055079s ]
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 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063937s ]
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 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053696s ]
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 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.127283s ]
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 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.117780s ]
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 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.136337s ]
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 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.085972s ]
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 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024070s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'mr-3%' OR `brand` LIKE 'mr-3%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.159545s ]