SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002568s ]
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 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003518s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12941652 LIMIT 5 [ RunTime:0.005428s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12941652 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12941652 ORDER BY `unit` DESC [ RunTime:0.000309s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12941652 LIMIT 2 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12941652 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12941651 LIMIT 5 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12941651 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12941651 ORDER BY `unit` DESC [ RunTime:0.000498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12941651 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12941651 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930720 LIMIT 5 [ RunTime:0.000843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930720 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930720 ORDER BY `unit` DESC [ RunTime:0.000469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930720 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930720 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930715 LIMIT 5 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930715 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930715 ORDER BY `unit` DESC [ RunTime:0.000465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930715 LIMIT 2 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930715 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930708 LIMIT 5 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930708 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930708 ORDER BY `unit` DESC [ RunTime:0.000407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930708 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930708 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930704 LIMIT 5 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930704 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930704 ORDER BY `unit` DESC [ RunTime:0.000497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930704 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930704 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930703 LIMIT 5 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930703 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930703 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930703 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930703 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930702 LIMIT 5 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930702 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930702 ORDER BY `unit` DESC [ RunTime:0.000407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930702 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930702 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12930698 LIMIT 5 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930698 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12930698 ORDER BY `unit` DESC [ RunTime:0.000401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12930698 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12930698 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726386 LIMIT 5 [ RunTime:0.001429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726386 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11726386 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11726386 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726386 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726385 LIMIT 5 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726385 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11726385 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11726385 LIMIT 2 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726385 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726384 LIMIT 5 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726384 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11726384 ORDER BY `unit` DESC [ RunTime:0.000460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11726384 LIMIT 2 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726384 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726382 LIMIT 5 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726382 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11726382 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11726382 LIMIT 2 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726382 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726380 LIMIT 5 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726380 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11726380 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11726380 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726380 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726379 LIMIT 5 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726379 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11726379 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11726379 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726379 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11726377 LIMIT 5 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726377 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11726377 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11726377 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11726377 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718869 LIMIT 5 [ RunTime:0.002180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718869 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11718869 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11718869 LIMIT 2 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718869 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718868 LIMIT 5 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718868 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11718868 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11718868 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718868 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11718865 LIMIT 5 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718865 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11718865 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11718865 LIMIT 2 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11718865 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11118184 LIMIT 5 [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11118184 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11118184 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11118184 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11118184 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
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 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000910s ]
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 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68704132 LIMIT 5 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68704132 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68704132 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68704132 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68704132 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
select * from pdf where partno='JT00RE-24-1SA(302)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001440s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(302)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000694s ]
SELECT `id` FROM `stock` WHERE `id` <> 68704132 AND `partno` = 'JT00RE-24-1SA(302)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68704130 LIMIT 5 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68704130 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68704130 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68704130 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68704130 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='JT00RE-24-1SA(434)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(434)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000528s ]
SELECT `id` FROM `stock` WHERE `id` <> 68704130 AND `partno` = 'JT00RE-24-1SA(434)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68704127 LIMIT 5 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68704127 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68704127 ORDER BY `unit` DESC [ RunTime:0.001953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68704127 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68704127 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
select * from pdf where partno='JT00RE-24-1SA(345)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(345)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000695s ]
SELECT `id` FROM `stock` WHERE `id` <> 68704127 AND `partno` = 'JT00RE-24-1SA(345)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68704120 LIMIT 5 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68704120 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68704120 ORDER BY `unit` DESC [ RunTime:0.000475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68704120 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68704120 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='JT00RE-24-1SA(363)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(363)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000610s ]
SELECT `id` FROM `stock` WHERE `id` <> 68704120 AND `partno` = 'JT00RE-24-1SA(363)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688729 LIMIT 5 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688729 ORDER BY `minOrder` ASC [ RunTime:0.000902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688729 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688729 LIMIT 2 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688729 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='JT00RE-24-1SA(300)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(300)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000621s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688729 AND `partno` = 'JT00RE-24-1SA(300)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688728 LIMIT 5 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688728 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688728 ORDER BY `unit` DESC [ RunTime:0.000469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688728 LIMIT 2 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688728 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
select * from pdf where partno='JT00RE-24-1SA(344)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(344)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000616s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688728 AND `partno` = 'JT00RE-24-1SA(344)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688727 LIMIT 5 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688727 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688727 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688727 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688727 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='JT00RE-24-1SA(382)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(382)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000590s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688727 AND `partno` = 'JT00RE-24-1SA(382)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688726 LIMIT 5 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688726 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688726 ORDER BY `unit` DESC [ RunTime:0.000488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688726 LIMIT 2 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688726 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='JT00RE-24-1SA(SR)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.001533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(SR)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000620s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688726 AND `partno` = 'JT00RE-24-1SA(SR)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688725 LIMIT 5 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688725 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688725 ORDER BY `unit` DESC [ RunTime:0.000488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688725 LIMIT 2 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688725 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='JT00RE-24-1SA(301)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(301)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000625s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688725 AND `partno` = 'JT00RE-24-1SA(301)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688724 LIMIT 5 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688724 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688724 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688724 LIMIT 2 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688724 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='JT00RE-24-1SA(424)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(424)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000595s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688724 AND `partno` = 'JT00RE-24-1SA(424)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688723 LIMIT 5 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688723 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688723 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688723 LIMIT 2 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688723 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='JT00RE-24-1SA(304)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(304)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000622s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688723 AND `partno` = 'JT00RE-24-1SA(304)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688722 LIMIT 5 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688722 ORDER BY `minOrder` ASC [ RunTime:0.000762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688722 ORDER BY `unit` DESC [ RunTime:0.000517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688722 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688722 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
select * from pdf where partno='JT00RE-24-1SA(386)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(386)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000617s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688722 AND `partno` = 'JT00RE-24-1SA(386)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688721 LIMIT 5 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688721 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688721 ORDER BY `unit` DESC [ RunTime:0.000516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688721 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688721 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='JT00RE-24-1SA(362)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(362)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000602s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688721 AND `partno` = 'JT00RE-24-1SA(362)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688720 LIMIT 5 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688720 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688720 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688720 LIMIT 2 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688720 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='JT00RE-24-1SA(416)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(416)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000623s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688720 AND `partno` = 'JT00RE-24-1SA(416)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688019 LIMIT 5 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688019 ORDER BY `minOrder` ASC [ RunTime:0.003174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688019 ORDER BY `unit` DESC [ RunTime:0.000531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688019 LIMIT 2 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688019 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
select * from pdf where partno='JT00RE-24-1SA(433)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(433)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000611s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688019 AND `partno` = 'JT00RE-24-1SA(433)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688016 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688016 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688016 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688016 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688016 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
select * from pdf where partno='JT00RE-24-1SA(328)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(328)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000588s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688016 AND `partno` = 'JT00RE-24-1SA(328)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688014 LIMIT 5 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688014 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688014 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688014 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688014 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='JT00RE-24-1SA(318)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(318)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000652s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688014 AND `partno` = 'JT00RE-24-1SA(318)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688009 LIMIT 5 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688009 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688009 ORDER BY `unit` DESC [ RunTime:0.000488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688009 LIMIT 2 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688009 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='JT00RE-24-1SA(397)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(397)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000638s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688009 AND `partno` = 'JT00RE-24-1SA(397)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688008 LIMIT 5 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688008 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688008 ORDER BY `unit` DESC [ RunTime:0.000476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688008 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688008 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
select * from pdf where partno='JT00RE-24-1SA(409)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(409)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000593s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688008 AND `partno` = 'JT00RE-24-1SA(409)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68688007 LIMIT 5 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688007 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68688007 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68688007 LIMIT 2 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68688007 ORDER BY `minOrder` ASC [ RunTime:0.000539s ]
select * from pdf where partno='JT00RE-24-1SA(306)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00RE-24-1SA(306)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000659s ]
SELECT `id` FROM `stock` WHERE `id` <> 68688007 AND `partno` = 'JT00RE-24-1SA(306)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ 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 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001160s ]
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 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001033s ]
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 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001000s ]
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 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000970s ]
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 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001002s ]
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 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000959s ]
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 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001092s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'JT00RE-24-1SA%' OR `brand` LIKE 'JT00RE-24-1SA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001250s ]