SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001590s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.172' , `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=1590wu&search=1' [ RunTime:0.001807s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001599s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001860s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002339s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.172' ) [ RunTime:0.000660s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002212s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000516s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002110s ]
SELECT * FROM `stock_search` WHERE `partno` = '1590wu' LIMIT 1 [ RunTime:0.001165s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-09-05 19:24:30' WHERE `partno` = '1590wu' [ RunTime:0.002886s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002269s ]
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 '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002950s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033565 LIMIT 5 [ RunTime:0.000995s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19033565 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19033565 ORDER BY `unit` DESC [ RunTime:0.000695s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19033565 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19033565 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032556 LIMIT 5 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032556 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19032556 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19032556 LIMIT 2 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032556 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277387 LIMIT 5 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277387 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15277387 ORDER BY `unit` DESC [ RunTime:0.000547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15277387 LIMIT 2 [ RunTime:0.000530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277387 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035709 LIMIT 5 [ RunTime:0.000980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035709 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19035709 ORDER BY `unit` DESC [ RunTime:0.000587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19035709 LIMIT 2 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035709 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277426 LIMIT 5 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277426 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15277426 ORDER BY `unit` DESC [ RunTime:0.000466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15277426 LIMIT 2 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277426 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032555 LIMIT 5 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032555 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19032555 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19032555 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032555 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
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 '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077626 LIMIT 5 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077626 ORDER BY `minOrder` ASC [ RunTime:0.000840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077626 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077626 LIMIT 2 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077626 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='1590wubk' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000745s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590wubk' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.001128s ]
SELECT `id` FROM `stock` WHERE `id` <> 51077626 AND `partno` = '1590wubk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035709 [ RunTime:0.000545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077579 LIMIT 5 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077579 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077579 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077579 LIMIT 2 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077579 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
select * from pdf where partno='1590wuf' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590wuf' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000625s ]
SELECT `id` FROM `stock` WHERE `id` <> 51077579 AND `partno` = '1590wuf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277387 [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32223321 LIMIT 5 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32223321 ORDER BY `minOrder` ASC [ RunTime:0.000951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32223321 ORDER BY `unit` DESC [ RunTime:0.000502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32223321 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32223321 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
select * from pdf where partno='1590wu' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590wu' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000623s ]
SELECT `id` FROM `stock` WHERE `id` <> 32223321 AND `partno` = '1590wu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032556 [ RunTime:0.000568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32223322 LIMIT 5 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32223322 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32223322 ORDER BY `unit` DESC [ RunTime:0.000500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32223322 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32223322 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
select * from pdf where partno='1590wuflbk' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590wuflbk' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000802s ]
SELECT `id` FROM `stock` WHERE `id` <> 32223322 AND `partno` = '1590wuflbk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033565 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32223009 LIMIT 5 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32223009 ORDER BY `minOrder` ASC [ RunTime:0.001070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32223009 ORDER BY `unit` DESC [ RunTime:0.000693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32223009 LIMIT 2 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32223009 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
select * from pdf where partno='1590wufbk' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590wufbk' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000796s ]
SELECT `id` FROM `stock` WHERE `id` <> 32223009 AND `partno` = '1590wufbk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.001939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277426 [ RunTime:0.000652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32223010 LIMIT 5 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32223010 ORDER BY `minOrder` ASC [ RunTime:0.000681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32223010 ORDER BY `unit` DESC [ RunTime:0.000659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32223010 LIMIT 2 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32223010 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
select * from pdf where partno='1590wufl' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590wufl' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000719s ]
SELECT `id` FROM `stock` WHERE `id` <> 32223010 AND `partno` = '1590wufl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032555 [ RunTime:0.000557s ]
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 '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70205047 LIMIT 5 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70205047 ORDER BY `minOrder` ASC [ RunTime:0.001138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70205047 ORDER BY `unit` DESC [ RunTime:0.000624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70205047 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70205047 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
select * from pdf where partno='1590WU' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590WU' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000743s ]
SELECT `id` FROM `stock` WHERE `id` <> 70205047 AND `partno` = '1590WU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032556 [ RunTime:0.000583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70206265 LIMIT 5 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70206265 ORDER BY `minOrder` ASC [ RunTime:0.002098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70206265 ORDER BY `unit` DESC [ RunTime:0.000565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70206265 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70206265 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
select * from pdf where partno='1590WUFL' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590WUFL' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000790s ]
SELECT `id` FROM `stock` WHERE `id` <> 70206265 AND `partno` = '1590WUFL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032555 [ RunTime:0.000615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70212219 LIMIT 5 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70212219 ORDER BY `minOrder` ASC [ RunTime:0.002802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70212219 ORDER BY `unit` DESC [ RunTime:0.000529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70212219 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70212219 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
select * from pdf where partno='1590WUBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590WUBK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000840s ]
SELECT `id` FROM `stock` WHERE `id` <> 70212219 AND `partno` = '1590WUBK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035709 [ RunTime:0.000697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70212343 LIMIT 5 [ RunTime:0.000754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70212343 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70212343 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70212343 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70212343 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
select * from pdf where partno='1590WUF' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590WUF' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000628s ]
SELECT `id` FROM `stock` WHERE `id` <> 70212343 AND `partno` = '1590WUF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277387 [ RunTime:0.000641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70212452 LIMIT 5 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70212452 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70212452 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70212452 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70212452 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
select * from pdf where partno='1590WUFBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590WUFBK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000785s ]
SELECT `id` FROM `stock` WHERE `id` <> 70212452 AND `partno` = '1590WUFBK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277426 [ RunTime:0.000507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70212222 LIMIT 5 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70212222 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70212222 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70212222 LIMIT 2 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70212222 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='1590WUFLBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590WUFLBK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000492s ]
SELECT `id` FROM `stock` WHERE `id` <> 70212222 AND `partno` = '1590WUFLBK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033565 [ RunTime:0.000424s ]
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 '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000968s ]
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 '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000864s ]
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 '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000722s ]
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 '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000585s ]
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 '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000636s ]
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 '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000682s ]
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 '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000809s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1590wu%' OR `brand` LIKE '1590wu%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000814s ]