SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002070s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.72' , `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=LJT00RE-21-11S&search=1' [ RunTime:0.016888s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002475s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000567s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002562s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.005248s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001976s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001967s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LJT00RE-21-11S' LIMIT 1 [ RunTime:0.001060s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-07 15:53:45' WHERE `partno` = 'LJT00RE-21-11S' [ RunTime:0.005118s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002016s ]
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 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006075s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944035 LIMIT 5 [ RunTime:0.018415s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944035 ORDER BY `minOrder` ASC [ RunTime:0.004247s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944035 ORDER BY `unit` DESC [ RunTime:0.012941s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.023870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944035 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944035 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944034 LIMIT 5 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944034 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944034 ORDER BY `unit` DESC [ RunTime:0.015160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944034 LIMIT 2 [ RunTime:0.007071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944034 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944033 LIMIT 5 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944033 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944033 ORDER BY `unit` DESC [ RunTime:0.008142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944033 LIMIT 2 [ RunTime:0.005845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944033 ORDER BY `minOrder` ASC [ RunTime:0.010616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944032 LIMIT 5 [ RunTime:0.014415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944032 ORDER BY `minOrder` ASC [ RunTime:0.003221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944032 ORDER BY `unit` DESC [ RunTime:0.025140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944032 LIMIT 2 [ RunTime:0.003067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944032 ORDER BY `minOrder` ASC [ RunTime:0.010888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944031 LIMIT 5 [ RunTime:0.008500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944031 ORDER BY `minOrder` ASC [ RunTime:0.018740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944031 ORDER BY `unit` DESC [ RunTime:0.008402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944031 LIMIT 2 [ RunTime:0.001942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944031 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944030 LIMIT 5 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944030 ORDER BY `minOrder` ASC [ RunTime:0.003347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944030 ORDER BY `unit` DESC [ RunTime:0.003281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944030 LIMIT 2 [ RunTime:0.003610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944030 ORDER BY `minOrder` ASC [ RunTime:0.002486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944029 LIMIT 5 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944029 ORDER BY `minOrder` ASC [ RunTime:0.008297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944029 ORDER BY `unit` DESC [ RunTime:0.003409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944029 LIMIT 2 [ RunTime:0.002801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944029 ORDER BY `minOrder` ASC [ RunTime:0.002943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944028 LIMIT 5 [ RunTime:0.004770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944028 ORDER BY `minOrder` ASC [ RunTime:0.007903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944028 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944028 LIMIT 2 [ RunTime:0.012156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944028 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944027 LIMIT 5 [ RunTime:0.002702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944027 ORDER BY `minOrder` ASC [ RunTime:0.005223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944027 ORDER BY `unit` DESC [ RunTime:0.002518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944027 LIMIT 2 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944027 ORDER BY `minOrder` ASC [ RunTime:0.001132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944007 LIMIT 5 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944007 ORDER BY `minOrder` ASC [ RunTime:0.002780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944007 ORDER BY `unit` DESC [ RunTime:0.005047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944007 LIMIT 2 [ RunTime:0.002143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944007 ORDER BY `minOrder` ASC [ RunTime:0.002316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944006 LIMIT 5 [ RunTime:0.001233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944006 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944006 ORDER BY `unit` DESC [ RunTime:0.000610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944006 LIMIT 2 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944006 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944005 LIMIT 5 [ RunTime:0.002255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944005 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944005 ORDER BY `unit` DESC [ RunTime:0.000608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944005 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944005 ORDER BY `minOrder` ASC [ RunTime:0.002182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944004 LIMIT 5 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944004 ORDER BY `minOrder` ASC [ RunTime:0.004453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12944004 ORDER BY `unit` DESC [ RunTime:0.015851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12944004 LIMIT 2 [ RunTime:0.008049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12944004 ORDER BY `minOrder` ASC [ RunTime:0.003602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11117659 LIMIT 5 [ RunTime:0.022872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11117659 ORDER BY `minOrder` ASC [ RunTime:0.004900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11117659 ORDER BY `unit` DESC [ RunTime:0.003909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11117659 LIMIT 2 [ RunTime:0.003714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11117659 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11117658 LIMIT 5 [ RunTime:0.002362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11117658 ORDER BY `minOrder` ASC [ RunTime:0.001532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11117658 ORDER BY `unit` DESC [ RunTime:0.000579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11117658 LIMIT 2 [ RunTime:0.003935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11117658 ORDER BY `minOrder` ASC [ RunTime:0.013116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11117657 LIMIT 5 [ RunTime:0.004435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11117657 ORDER BY `minOrder` ASC [ RunTime:0.001354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11117657 ORDER BY `unit` DESC [ RunTime:0.000728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11117657 LIMIT 2 [ RunTime:0.009018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11117657 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11117656 LIMIT 5 [ RunTime:0.002596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11117656 ORDER BY `minOrder` ASC [ RunTime:0.017517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11117656 ORDER BY `unit` DESC [ RunTime:0.015875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11117656 LIMIT 2 [ RunTime:0.007152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11117656 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
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 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005532s ]
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 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61859545 LIMIT 5 [ RunTime:0.021173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61859545 ORDER BY `minOrder` ASC [ RunTime:0.030829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61859545 ORDER BY `unit` DESC [ RunTime:0.000703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61859545 LIMIT 2 [ RunTime:0.000787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61859545 ORDER BY `minOrder` ASC [ RunTime:0.002517s ]
select * from pdf where partno='LJT00RE-21-11S(344)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.036628s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S(344)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002589s ]
SELECT `id` FROM `stock` WHERE `id` <> 61859545 AND `partno` = 'LJT00RE-21-11S(344)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.023809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61859544 LIMIT 5 [ RunTime:0.005793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61859544 ORDER BY `minOrder` ASC [ RunTime:0.001428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61859544 ORDER BY `unit` DESC [ RunTime:0.010323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61859544 LIMIT 2 [ RunTime:0.023539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61859544 ORDER BY `minOrder` ASC [ RunTime:0.004278s ]
select * from pdf where partno='LJT00RE-21-11S(424)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S(424)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003923s ]
SELECT `id` FROM `stock` WHERE `id` <> 61859544 AND `partno` = 'LJT00RE-21-11S(424)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61835815 LIMIT 5 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61835815 ORDER BY `minOrder` ASC [ RunTime:0.010364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61835815 ORDER BY `unit` DESC [ RunTime:0.001368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61835815 LIMIT 2 [ RunTime:0.023888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61835815 ORDER BY `minOrder` ASC [ RunTime:0.014346s ]
select * from pdf where partno='LJT00RE-21-11S(011)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S(011)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.012254s ]
SELECT `id` FROM `stock` WHERE `id` <> 61835815 AND `partno` = 'LJT00RE-21-11S(011)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.014143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11117659 [ RunTime:0.006126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61835814 LIMIT 5 [ RunTime:0.004237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61835814 ORDER BY `minOrder` ASC [ RunTime:0.000917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61835814 ORDER BY `unit` DESC [ RunTime:0.009614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61835814 LIMIT 2 [ RunTime:0.013962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61835814 ORDER BY `minOrder` ASC [ RunTime:0.003208s ]
select * from pdf where partno='LJT00RE-21-11S(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.011733s ]
SELECT `id` FROM `stock` WHERE `id` <> 61835814 AND `partno` = 'LJT00RE-21-11S(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11117657 [ RunTime:0.011595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61170616 LIMIT 5 [ RunTime:0.002447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61170616 ORDER BY `minOrder` ASC [ RunTime:0.017940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61170616 ORDER BY `unit` DESC [ RunTime:0.000869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61170616 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61170616 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='LJT00RE-21-11S(386)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S(386)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.011904s ]
SELECT `id` FROM `stock` WHERE `id` <> 61170616 AND `partno` = 'LJT00RE-21-11S(386)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61170615 LIMIT 5 [ RunTime:0.013191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61170615 ORDER BY `minOrder` ASC [ RunTime:0.006941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61170615 ORDER BY `unit` DESC [ RunTime:0.009212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61170615 LIMIT 2 [ RunTime:0.008693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61170615 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='LJT00RE-21-11S(SR)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.005525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S(SR)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.001120s ]
SELECT `id` FROM `stock` WHERE `id` <> 61170615 AND `partno` = 'LJT00RE-21-11S(SR)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.008434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61169999 LIMIT 5 [ RunTime:0.012696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61169999 ORDER BY `minOrder` ASC [ RunTime:0.016260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61169999 ORDER BY `unit` DESC [ RunTime:0.003396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61169999 LIMIT 2 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61169999 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='LJT00RE-21-11S(014)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S(014)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.021777s ]
SELECT `id` FROM `stock` WHERE `id` <> 61169999 AND `partno` = 'LJT00RE-21-11S(014)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11117658 [ RunTime:0.000896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61169998 LIMIT 5 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61169998 ORDER BY `minOrder` ASC [ RunTime:0.020464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61169998 ORDER BY `unit` DESC [ RunTime:0.008218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61169998 LIMIT 2 [ RunTime:0.005042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61169998 ORDER BY `minOrder` ASC [ RunTime:0.002641s ]
select * from pdf where partno='LJT00RE-21-11S' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.004334s ]
SELECT `id` FROM `stock` WHERE `id` <> 61169998 AND `partno` = 'LJT00RE-21-11S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11117656 [ RunTime:0.006059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250383 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250383 ORDER BY `minOrder` ASC [ RunTime:0.001164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250383 ORDER BY `unit` DESC [ RunTime:0.002881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250383 LIMIT 2 [ RunTime:0.007315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250383 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='LJT00RE-21-11SC(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11SC(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002985s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250383 AND `partno` = 'LJT00RE-21-11SC(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.020283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250382 LIMIT 5 [ RunTime:0.003921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250382 ORDER BY `minOrder` ASC [ RunTime:0.026799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250382 ORDER BY `unit` DESC [ RunTime:0.014342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250382 LIMIT 2 [ RunTime:0.016509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250382 ORDER BY `minOrder` ASC [ RunTime:0.009317s ]
select * from pdf where partno='LJT00RE-21-11SC(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11SC(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003817s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250382 AND `partno` = 'LJT00RE-21-11SC(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250381 LIMIT 5 [ RunTime:0.031522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250381 ORDER BY `minOrder` ASC [ RunTime:0.009226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250381 ORDER BY `unit` DESC [ RunTime:0.006170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250381 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250381 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='LJT00RE-21-11SC(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.003593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11SC(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000737s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250381 AND `partno` = 'LJT00RE-21-11SC(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250355 LIMIT 5 [ RunTime:0.007496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250355 ORDER BY `minOrder` ASC [ RunTime:0.006759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250355 ORDER BY `unit` DESC [ RunTime:0.007108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250355 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250355 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
select * from pdf where partno='LJT00RE-21-11SB(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.009454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11SB(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.011078s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250355 AND `partno` = 'LJT00RE-21-11SB(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.015951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944035 [ RunTime:0.001977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250354 LIMIT 5 [ RunTime:0.008596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250354 ORDER BY `minOrder` ASC [ RunTime:0.014302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250354 ORDER BY `unit` DESC [ RunTime:0.003584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250354 LIMIT 2 [ RunTime:0.001939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250354 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='LJT00RE-21-11SA(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.002829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11SA(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003071s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250354 AND `partno` = 'LJT00RE-21-11SA(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944034 [ RunTime:0.000729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250353 LIMIT 5 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250353 ORDER BY `minOrder` ASC [ RunTime:0.002084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250353 ORDER BY `unit` DESC [ RunTime:0.001824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250353 LIMIT 2 [ RunTime:0.003100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250353 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
select * from pdf where partno='LJT00RE-21-11SB(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.002855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11SB(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000639s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250353 AND `partno` = 'LJT00RE-21-11SB(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944032 [ RunTime:0.000318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250352 LIMIT 5 [ RunTime:0.001169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250352 ORDER BY `minOrder` ASC [ RunTime:0.002685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250352 ORDER BY `unit` DESC [ RunTime:0.002238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250352 LIMIT 2 [ RunTime:0.002532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250352 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
select * from pdf where partno='LJT00RE-21-11SB(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11SB(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003055s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250352 AND `partno` = 'LJT00RE-21-11SB(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944030 [ RunTime:0.002516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250351 LIMIT 5 [ RunTime:0.002588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250351 ORDER BY `minOrder` ASC [ RunTime:0.003418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250351 ORDER BY `unit` DESC [ RunTime:0.004123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250351 LIMIT 2 [ RunTime:0.001717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250351 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='LJT00RE-21-11S(023LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.002730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S(023LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000539s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250351 AND `partno` = 'LJT00RE-21-11S(023LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944029 [ RunTime:0.000871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250350 LIMIT 5 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250350 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250350 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250350 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250350 ORDER BY `minOrder` ASC [ RunTime:0.000195s ]
select * from pdf where partno='LJT00RE-21-11S(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003984s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250350 AND `partno` = 'LJT00RE-21-11S(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944028 [ RunTime:0.000890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250349 LIMIT 5 [ RunTime:0.003582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250349 ORDER BY `minOrder` ASC [ RunTime:0.013481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250349 ORDER BY `unit` DESC [ RunTime:0.016053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250349 LIMIT 2 [ RunTime:0.014423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250349 ORDER BY `minOrder` ASC [ RunTime:0.000932s ]
select * from pdf where partno='LJT00RE-21-11SA(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.002587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11SA(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000878s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250349 AND `partno` = 'LJT00RE-21-11SA(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12944027 [ RunTime:0.011630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250347 LIMIT 5 [ RunTime:0.017231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250347 ORDER BY `minOrder` ASC [ RunTime:0.007864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250347 ORDER BY `unit` DESC [ RunTime:0.004501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250347 LIMIT 2 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250347 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='LJT00RE-21-11SA(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11SA(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002497s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250347 AND `partno` = 'LJT00RE-21-11SA(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.006908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60250344 LIMIT 5 [ RunTime:0.002667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250344 ORDER BY `minOrder` ASC [ RunTime:0.001514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60250344 ORDER BY `unit` DESC [ RunTime:0.000647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60250344 LIMIT 2 [ RunTime:0.009740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60250344 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
select * from pdf where partno='LJT00RE-21-11S(011LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LJT00RE-21-11S(011LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.002017s ]
SELECT `id` FROM `stock` WHERE `id` <> 60250344 AND `partno` = 'LJT00RE-21-11S(011LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000613s ]
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 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000787s ]
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 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008913s ]
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 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004043s ]
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 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002610s ]
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 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000618s ]
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 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000658s ]
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 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007402s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LJT00RE-21-11S%' OR `brand` LIKE 'LJT00RE-21-11S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001064s ]