SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002135s ]
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 '15540%' OR `brand` LIKE '15540%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029664s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.027012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513188 LIMIT 5 [ RunTime:0.024607s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513188 ORDER BY `minOrder` ASC [ RunTime:0.004454s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513188 ORDER BY `unit` DESC [ RunTime:0.019418s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513188 LIMIT 2 [ RunTime:0.006969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513188 ORDER BY `minOrder` ASC [ RunTime:0.010143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14692597 LIMIT 5 [ RunTime:0.004970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692597 ORDER BY `minOrder` ASC [ RunTime:0.000703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14692597 ORDER BY `unit` DESC [ RunTime:0.000584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14692597 LIMIT 2 [ RunTime:0.011256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692597 ORDER BY `minOrder` ASC [ RunTime:0.000631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13103775 LIMIT 5 [ RunTime:0.018610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13103775 ORDER BY `minOrder` ASC [ RunTime:0.004620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13103775 ORDER BY `unit` DESC [ RunTime:0.000616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13103775 LIMIT 2 [ RunTime:0.014222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13103775 ORDER BY `minOrder` ASC [ RunTime:0.001654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647051 LIMIT 5 [ RunTime:0.003202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647051 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647051 ORDER BY `unit` DESC [ RunTime:0.015951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647051 LIMIT 2 [ RunTime:0.003214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647051 ORDER BY `minOrder` ASC [ RunTime:0.001869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647050 LIMIT 5 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647050 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647050 ORDER BY `unit` DESC [ RunTime:0.016722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647050 LIMIT 2 [ RunTime:0.007240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647050 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19028117 LIMIT 5 [ RunTime:0.004254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19028117 ORDER BY `minOrder` ASC [ RunTime:0.011339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19028117 ORDER BY `unit` DESC [ RunTime:0.000739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19028117 LIMIT 2 [ RunTime:0.006834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19028117 ORDER BY `minOrder` ASC [ RunTime:0.006707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17503810 LIMIT 5 [ RunTime:0.007757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17503810 ORDER BY `minOrder` ASC [ RunTime:0.012892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17503810 ORDER BY `unit` DESC [ RunTime:0.030046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17503810 LIMIT 2 [ RunTime:0.016333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17503810 ORDER BY `minOrder` ASC [ RunTime:0.005825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17501742 LIMIT 5 [ RunTime:0.007790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17501742 ORDER BY `minOrder` ASC [ RunTime:0.006974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17501742 ORDER BY `unit` DESC [ RunTime:0.017286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17501742 LIMIT 2 [ RunTime:0.001169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17501742 ORDER BY `minOrder` ASC [ RunTime:0.003418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14397037 LIMIT 5 [ RunTime:0.013834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14397037 ORDER BY `minOrder` ASC [ RunTime:0.007561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14397037 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14397037 LIMIT 2 [ RunTime:0.030354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14397037 ORDER BY `minOrder` ASC [ RunTime:0.003185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13795758 LIMIT 5 [ RunTime:0.008850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13795758 ORDER BY `minOrder` ASC [ RunTime:0.008889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13795758 ORDER BY `unit` DESC [ RunTime:0.004636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13795758 LIMIT 2 [ RunTime:0.013023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13795758 ORDER BY `minOrder` ASC [ RunTime:0.011952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13284037 LIMIT 5 [ RunTime:0.015791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284037 ORDER BY `minOrder` ASC [ RunTime:0.033452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13284037 ORDER BY `unit` DESC [ RunTime:0.016749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13284037 LIMIT 2 [ RunTime:0.013904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284037 ORDER BY `minOrder` ASC [ RunTime:0.005872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11449789 LIMIT 5 [ RunTime:0.008485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11449789 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11449789 ORDER BY `unit` DESC [ RunTime:0.000281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11449789 LIMIT 2 [ RunTime:0.009085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11449789 ORDER BY `minOrder` ASC [ RunTime:0.009744s ]
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 '15540%' OR `brand` LIKE '15540%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001188s ]
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 '15540%' OR `brand` LIKE '15540%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423615 LIMIT 5 [ RunTime:0.002866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423615 ORDER BY `minOrder` ASC [ RunTime:0.033280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423615 ORDER BY `unit` DESC [ RunTime:0.016582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423615 LIMIT 2 [ RunTime:0.010630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423615 ORDER BY `minOrder` ASC [ RunTime:0.010831s ]
select * from pdf where partno='1554000' and brandshort='Rittal' limit 1 [ RunTime:0.018611s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554000' OR `brand` LIKE 'Rittal%' ) ) LIMIT 1 [ RunTime:0.022225s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423615 AND `partno` = '1554000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rittal%' ) [ RunTime:0.002332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19028117 [ RunTime:0.016126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62134018 LIMIT 5 [ RunTime:0.008556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62134018 ORDER BY `minOrder` ASC [ RunTime:0.030550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62134018 ORDER BY `unit` DESC [ RunTime:0.032816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62134018 LIMIT 2 [ RunTime:0.015072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62134018 ORDER BY `minOrder` ASC [ RunTime:0.018153s ]
select * from pdf where partno='1554011' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554011' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60388691 LIMIT 5 [ RunTime:0.005257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60388691 ORDER BY `minOrder` ASC [ RunTime:0.002977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60388691 ORDER BY `unit` DESC [ RunTime:0.008477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60388691 LIMIT 2 [ RunTime:0.002116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60388691 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='1554000000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554000000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010317s ]
SELECT `id` FROM `stock` WHERE `id` <> 60388691 AND `partno` = '1554000000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13103775 [ RunTime:0.002767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64517998 LIMIT 5 [ RunTime:0.020336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64517998 ORDER BY `minOrder` ASC [ RunTime:0.012597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64517998 ORDER BY `unit` DESC [ RunTime:0.028385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64517998 LIMIT 2 [ RunTime:0.006709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64517998 ORDER BY `minOrder` ASC [ RunTime:0.006948s ]
select * from pdf where partno='15540' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15540' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.015888s ]
SELECT `id` FROM `stock` WHERE `id` <> 64517998 AND `partno` = '15540' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14397037 [ RunTime:0.000681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63371024 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63371024 ORDER BY `minOrder` ASC [ RunTime:0.006647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63371024 ORDER BY `unit` DESC [ RunTime:0.032346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63371024 LIMIT 2 [ RunTime:0.006623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63371024 ORDER BY `minOrder` ASC [ RunTime:0.006466s ]
select * from pdf where partno='15540B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15540B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.002097s ]
SELECT `id` FROM `stock` WHERE `id` <> 63371024 AND `partno` = '15540B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.015362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63371023 LIMIT 5 [ RunTime:0.014129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63371023 ORDER BY `minOrder` ASC [ RunTime:0.006171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63371023 ORDER BY `unit` DESC [ RunTime:0.010192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63371023 LIMIT 2 [ RunTime:0.003686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63371023 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='15540' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.007126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15540' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.023247s ]
SELECT `id` FROM `stock` WHERE `id` <> 63371023 AND `partno` = '15540' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.004067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62203830 LIMIT 5 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62203830 ORDER BY `minOrder` ASC [ RunTime:0.007689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62203830 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62203830 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62203830 ORDER BY `minOrder` ASC [ RunTime:0.001368s ]
select * from pdf where partno='1554034' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.017265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554034' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62201420 LIMIT 5 [ RunTime:0.014961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62201420 ORDER BY `minOrder` ASC [ RunTime:0.003072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62201420 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62201420 LIMIT 2 [ RunTime:0.014211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62201420 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='1554021' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554021' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62157657 LIMIT 5 [ RunTime:0.016837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62157657 ORDER BY `minOrder` ASC [ RunTime:0.008970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62157657 ORDER BY `unit` DESC [ RunTime:0.002438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62157657 LIMIT 2 [ RunTime:0.004411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62157657 ORDER BY `minOrder` ASC [ RunTime:0.001856s ]
select * from pdf where partno='15540' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.002970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15540' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.004843s ]
SELECT `id` FROM `stock` WHERE `id` <> 62157657 AND `partno` = '15540' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.008389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13795758 [ RunTime:0.007735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60648103 LIMIT 5 [ RunTime:0.008378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60648103 ORDER BY `minOrder` ASC [ RunTime:0.007033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60648103 ORDER BY `unit` DESC [ RunTime:0.016950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60648103 LIMIT 2 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60648103 ORDER BY `minOrder` ASC [ RunTime:0.003293s ]
select * from pdf where partno='155406-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '155406-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009696s ]
SELECT `id` FROM `stock` WHERE `id` <> 60648103 AND `partno` = '155406-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513188 [ RunTime:0.001346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60543483 LIMIT 5 [ RunTime:0.008858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60543483 ORDER BY `minOrder` ASC [ RunTime:0.000796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60543483 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60543483 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60543483 ORDER BY `minOrder` ASC [ RunTime:0.002442s ]
select * from pdf where partno='1554060000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554060000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011771s ]
SELECT `id` FROM `stock` WHERE `id` <> 60543483 AND `partno` = '1554060000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647051 [ RunTime:0.009849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60543482 LIMIT 5 [ RunTime:0.004206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60543482 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60543482 ORDER BY `unit` DESC [ RunTime:0.014250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60543482 LIMIT 2 [ RunTime:0.005640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60543482 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
select * from pdf where partno='1554010000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554010000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003235s ]
SELECT `id` FROM `stock` WHERE `id` <> 60543482 AND `partno` = '1554010000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647050 [ RunTime:0.003829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59998222 LIMIT 5 [ RunTime:0.000970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59998222 ORDER BY `minOrder` ASC [ RunTime:0.001128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59998222 ORDER BY `unit` DESC [ RunTime:0.000535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59998222 LIMIT 2 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59998222 ORDER BY `minOrder` ASC [ RunTime:0.001064s ]
select * from pdf where partno='1554098' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1554098' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59351065 LIMIT 5 [ RunTime:0.001238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59351065 ORDER BY `minOrder` ASC [ RunTime:0.002071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59351065 ORDER BY `unit` DESC [ RunTime:0.002965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59351065 LIMIT 2 [ RunTime:0.001555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59351065 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
select * from pdf where partno='15540' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15540' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000671s ]
SELECT `id` FROM `stock` WHERE `id` <> 59351065 AND `partno` = '15540' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.002223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11449789 [ RunTime:0.002845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32545728 LIMIT 5 [ RunTime:0.002452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32545728 ORDER BY `minOrder` ASC [ RunTime:0.018507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32545728 ORDER BY `unit` DESC [ RunTime:0.010575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32545728 LIMIT 2 [ RunTime:0.005189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32545728 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
select * from pdf where partno='15540031' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15540031' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005613s ]
SELECT `id` FROM `stock` WHERE `id` <> 32545728 AND `partno` = '15540031' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32543538 LIMIT 5 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32543538 ORDER BY `minOrder` ASC [ RunTime:0.000900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32543538 ORDER BY `unit` DESC [ RunTime:0.000444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32543538 LIMIT 2 [ RunTime:0.002891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32543538 ORDER BY `minOrder` ASC [ RunTime:0.003931s ]
select * from pdf where partno='15540012' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15540012' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001231s ]
SELECT `id` FROM `stock` WHERE `id` <> 32543538 AND `partno` = '15540012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003120s ]
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 '15540%' OR `brand` LIKE '15540%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012579s ]
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 '15540%' OR `brand` LIKE '15540%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002563s ]
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 '15540%' OR `brand` LIKE '15540%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009088s ]
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 '15540%' OR `brand` LIKE '15540%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003536s ]
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 '15540%' OR `brand` LIKE '15540%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002584s ]
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 '15540%' OR `brand` LIKE '15540%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000724s ]
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 '15540%' OR `brand` LIKE '15540%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002778s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15540%' OR `brand` LIKE '15540%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015255s ]