SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002813s ]
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 '19353%' OR `brand` LIKE '19353%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.185822s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442971 LIMIT 5 [ RunTime:0.034211s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442971 ORDER BY `minOrder` ASC [ RunTime:0.031333s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11442971 ORDER BY `unit` DESC [ RunTime:0.028228s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11442971 LIMIT 2 [ RunTime:0.050820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442971 ORDER BY `minOrder` ASC [ RunTime:0.023454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12557196 LIMIT 5 [ RunTime:0.099426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12557196 ORDER BY `minOrder` ASC [ RunTime:0.070810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12557196 ORDER BY `unit` DESC [ RunTime:0.081094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12557196 LIMIT 2 [ RunTime:0.099150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12557196 ORDER BY `minOrder` ASC [ RunTime:0.043029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12554294 LIMIT 5 [ RunTime:0.047023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12554294 ORDER BY `minOrder` ASC [ RunTime:0.060808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12554294 ORDER BY `unit` DESC [ RunTime:0.061452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12554294 LIMIT 2 [ RunTime:0.061966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12554294 ORDER BY `minOrder` ASC [ RunTime:0.035560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579702 LIMIT 5 [ RunTime:0.082318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579702 ORDER BY `minOrder` ASC [ RunTime:0.082853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579702 ORDER BY `unit` DESC [ RunTime:0.063000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579702 LIMIT 2 [ RunTime:0.082888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579702 ORDER BY `minOrder` ASC [ RunTime:0.039798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12555417 LIMIT 5 [ RunTime:0.012794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12555417 ORDER BY `minOrder` ASC [ RunTime:0.051235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12555417 ORDER BY `unit` DESC [ RunTime:0.024844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12555417 LIMIT 2 [ RunTime:0.044528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12555417 ORDER BY `minOrder` ASC [ RunTime:0.015044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556839 LIMIT 5 [ RunTime:0.013651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556839 ORDER BY `minOrder` ASC [ RunTime:0.006135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556839 ORDER BY `unit` DESC [ RunTime:0.025726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556839 LIMIT 2 [ RunTime:0.010791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556839 ORDER BY `minOrder` ASC [ RunTime:0.007258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186312 LIMIT 5 [ RunTime:0.020497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186312 ORDER BY `minOrder` ASC [ RunTime:0.024428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11186312 ORDER BY `unit` DESC [ RunTime:0.007110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11186312 LIMIT 2 [ RunTime:0.022836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186312 ORDER BY `minOrder` ASC [ RunTime:0.009606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578113 LIMIT 5 [ RunTime:0.008129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578113 ORDER BY `minOrder` ASC [ RunTime:0.011342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578113 ORDER BY `unit` DESC [ RunTime:0.008427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578113 LIMIT 2 [ RunTime:0.001602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578113 ORDER BY `minOrder` ASC [ RunTime:0.002586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431864 LIMIT 5 [ RunTime:0.003820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431864 ORDER BY `minOrder` ASC [ RunTime:0.018957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431864 ORDER BY `unit` DESC [ RunTime:0.007737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431864 LIMIT 2 [ RunTime:0.020120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431864 ORDER BY `minOrder` ASC [ RunTime:0.009925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14691610 LIMIT 5 [ RunTime:0.003320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14691610 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14691610 ORDER BY `unit` DESC [ RunTime:0.020183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14691610 LIMIT 2 [ RunTime:0.050027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14691610 ORDER BY `minOrder` ASC [ RunTime:0.006151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14413931 LIMIT 5 [ RunTime:0.018046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14413931 ORDER BY `minOrder` ASC [ RunTime:0.014155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14413931 ORDER BY `unit` DESC [ RunTime:0.058329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14413931 LIMIT 2 [ RunTime:0.039140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14413931 ORDER BY `minOrder` ASC [ RunTime:0.028586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543424 LIMIT 5 [ RunTime:0.041479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543424 ORDER BY `minOrder` ASC [ RunTime:0.012026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13543424 ORDER BY `unit` DESC [ RunTime:0.007602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13543424 LIMIT 2 [ RunTime:0.004439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543424 ORDER BY `minOrder` ASC [ RunTime:0.008886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503918 LIMIT 5 [ RunTime:0.012064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503918 ORDER BY `minOrder` ASC [ RunTime:0.012943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13503918 ORDER BY `unit` DESC [ RunTime:0.012129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13503918 LIMIT 2 [ RunTime:0.002175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503918 ORDER BY `minOrder` ASC [ RunTime:0.000979s ]
select * from pdf where partno='19353 010250' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556825 LIMIT 5 [ RunTime:0.008493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556825 ORDER BY `minOrder` ASC [ RunTime:0.007133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556825 ORDER BY `unit` DESC [ RunTime:0.013478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556825 LIMIT 2 [ RunTime:0.006771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556825 ORDER BY `minOrder` ASC [ RunTime:0.003513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544587 LIMIT 5 [ RunTime:0.003811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544587 ORDER BY `minOrder` ASC [ RunTime:0.002785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12544587 ORDER BY `unit` DESC [ RunTime:0.002482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12544587 LIMIT 2 [ RunTime:0.005970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544587 ORDER BY `minOrder` ASC [ RunTime:0.007172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442987 LIMIT 5 [ RunTime:0.006122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442987 ORDER BY `minOrder` ASC [ RunTime:0.004282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11442987 ORDER BY `unit` DESC [ RunTime:0.015643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11442987 LIMIT 2 [ RunTime:0.006123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442987 ORDER BY `minOrder` ASC [ RunTime:0.006228s ]
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 '19353%' OR `brand` LIKE '19353%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137370 LIMIT 5 [ RunTime:0.018841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137370 ORDER BY `minOrder` ASC [ RunTime:0.011818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137370 ORDER BY `unit` DESC [ RunTime:0.018870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137370 LIMIT 2 [ RunTime:0.024798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137370 ORDER BY `minOrder` ASC [ RunTime:0.004532s ]
select * from pdf where partno='19353 010250' and brandshort='belden wire & cable' limit 1 [ RunTime:0.015482s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19353 010250' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.015825s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137370 AND `partno` = '19353 010250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.010581s ]
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 '19353%' OR `brand` LIKE '19353%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53737658 LIMIT 5 [ RunTime:0.014555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737658 ORDER BY `minOrder` ASC [ RunTime:0.023333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53737658 ORDER BY `unit` DESC [ RunTime:0.022306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53737658 LIMIT 2 [ RunTime:0.005921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737658 ORDER BY `minOrder` ASC [ RunTime:0.033585s ]
select * from pdf where partno='1935310' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.018649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935310' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.036111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53737807 LIMIT 5 [ RunTime:0.008786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737807 ORDER BY `minOrder` ASC [ RunTime:0.018580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53737807 ORDER BY `unit` DESC [ RunTime:0.045127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53737807 LIMIT 2 [ RunTime:0.040857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737807 ORDER BY `minOrder` ASC [ RunTime:0.011021s ]
select * from pdf where partno='1935336' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.032452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935336' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.054976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53738278 LIMIT 5 [ RunTime:0.052543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53738278 ORDER BY `minOrder` ASC [ RunTime:0.022820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53738278 ORDER BY `unit` DESC [ RunTime:0.026588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53738278 LIMIT 2 [ RunTime:0.054594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53738278 ORDER BY `minOrder` ASC [ RunTime:0.019775s ]
select * from pdf where partno='1935307' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.035672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935307' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.059050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53536716 LIMIT 5 [ RunTime:0.018307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536716 ORDER BY `minOrder` ASC [ RunTime:0.067268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53536716 ORDER BY `unit` DESC [ RunTime:0.099638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53536716 LIMIT 2 [ RunTime:0.087177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536716 ORDER BY `minOrder` ASC [ RunTime:0.047365s ]
select * from pdf where partno='193535-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.016331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '193535-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.047663s ]
SELECT `id` FROM `stock` WHERE `id` <> 53536716 AND `partno` = '193535-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.114471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579702 [ RunTime:0.096263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53741856 LIMIT 5 [ RunTime:0.052953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741856 ORDER BY `minOrder` ASC [ RunTime:0.190541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53741856 ORDER BY `unit` DESC [ RunTime:0.029810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53741856 LIMIT 2 [ RunTime:0.125497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741856 ORDER BY `minOrder` ASC [ RunTime:0.093879s ]
select * from pdf where partno='1935349' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.159527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935349' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.036965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53741908 LIMIT 5 [ RunTime:0.070440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741908 ORDER BY `minOrder` ASC [ RunTime:0.034090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53741908 ORDER BY `unit` DESC [ RunTime:0.079484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53741908 LIMIT 2 [ RunTime:0.117299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741908 ORDER BY `minOrder` ASC [ RunTime:0.012604s ]
select * from pdf where partno='1935378' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.101189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935378' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.026813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53741357 LIMIT 5 [ RunTime:0.036221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741357 ORDER BY `minOrder` ASC [ RunTime:0.040494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53741357 ORDER BY `unit` DESC [ RunTime:0.016534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53741357 LIMIT 2 [ RunTime:0.075521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741357 ORDER BY `minOrder` ASC [ RunTime:0.034744s ]
select * from pdf where partno='1935365' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.040533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935365' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.026028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53741867 LIMIT 5 [ RunTime:0.017430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741867 ORDER BY `minOrder` ASC [ RunTime:0.030194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53741867 ORDER BY `unit` DESC [ RunTime:0.018155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53741867 LIMIT 2 [ RunTime:0.040607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741867 ORDER BY `minOrder` ASC [ RunTime:0.021017s ]
select * from pdf where partno='1935352' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.018153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935352' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.037418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53741948 LIMIT 5 [ RunTime:0.005967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741948 ORDER BY `minOrder` ASC [ RunTime:0.016187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53741948 ORDER BY `unit` DESC [ RunTime:0.025461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53741948 LIMIT 2 [ RunTime:0.029231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741948 ORDER BY `minOrder` ASC [ RunTime:0.001583s ]
select * from pdf where partno='1935394' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.012645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935394' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.022631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53741161 LIMIT 5 [ RunTime:0.011612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741161 ORDER BY `minOrder` ASC [ RunTime:0.002945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53741161 ORDER BY `unit` DESC [ RunTime:0.000874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53741161 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741161 ORDER BY `minOrder` ASC [ RunTime:0.002585s ]
select * from pdf where partno='1935323' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935323' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51648493 LIMIT 5 [ RunTime:0.015327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51648493 ORDER BY `minOrder` ASC [ RunTime:0.006466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51648493 ORDER BY `unit` DESC [ RunTime:0.006880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51648493 LIMIT 2 [ RunTime:0.012109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51648493 ORDER BY `minOrder` ASC [ RunTime:0.002967s ]
select * from pdf where partno='19353' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.011067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19353' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.013730s ]
SELECT `id` FROM `stock` WHERE `id` <> 51648493 AND `partno` = '19353' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.050265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186312 [ RunTime:0.011585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56336089 LIMIT 5 [ RunTime:0.028799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56336089 ORDER BY `minOrder` ASC [ RunTime:0.035630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56336089 ORDER BY `unit` DESC [ RunTime:0.009073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56336089 LIMIT 2 [ RunTime:0.011488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56336089 ORDER BY `minOrder` ASC [ RunTime:0.009830s ]
select * from pdf where partno='19353.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.012541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19353.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.046667s ]
SELECT `id` FROM `stock` WHERE `id` <> 56336089 AND `partno` = '19353.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.038280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14413931 [ RunTime:0.016807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56334715 LIMIT 5 [ RunTime:0.007545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56334715 ORDER BY `minOrder` ASC [ RunTime:0.022315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56334715 ORDER BY `unit` DESC [ RunTime:0.072827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56334715 LIMIT 2 [ RunTime:0.014741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56334715 ORDER BY `minOrder` ASC [ RunTime:0.019026s ]
select * from pdf where partno='19353.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.021632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19353.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.035232s ]
SELECT `id` FROM `stock` WHERE `id` <> 56334715 AND `partno` = '19353.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.048120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431864 [ RunTime:0.019674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56334513 LIMIT 5 [ RunTime:0.047855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56334513 ORDER BY `minOrder` ASC [ RunTime:0.030552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56334513 ORDER BY `unit` DESC [ RunTime:0.049128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56334513 LIMIT 2 [ RunTime:0.048891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56334513 ORDER BY `minOrder` ASC [ RunTime:0.014325s ]
select * from pdf where partno='19353.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.039772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19353.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.018083s ]
SELECT `id` FROM `stock` WHERE `id` <> 56334513 AND `partno` = '19353.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.044236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543424 [ RunTime:0.021356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56192215 LIMIT 5 [ RunTime:0.032836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56192215 ORDER BY `minOrder` ASC [ RunTime:0.046453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56192215 ORDER BY `unit` DESC [ RunTime:0.051135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56192215 LIMIT 2 [ RunTime:0.068493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56192215 ORDER BY `minOrder` ASC [ RunTime:0.032249s ]
select * from pdf where partno='19353 010250' and brandshort='Belden Inc.' limit 1 [ RunTime:0.028053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19353 010250' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.010961s ]
SELECT `id` FROM `stock` WHERE `id` <> 56192215 AND `partno` = '19353 010250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.049604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503918 [ RunTime:0.033502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55371757 LIMIT 5 [ RunTime:0.037520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55371757 ORDER BY `minOrder` ASC [ RunTime:0.021216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55371757 ORDER BY `unit` DESC [ RunTime:0.023426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55371757 LIMIT 2 [ RunTime:0.019885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55371757 ORDER BY `minOrder` ASC [ RunTime:0.029177s ]
select * from pdf where partno='1935351000' and brandshort='Weidmüller' limit 1 [ RunTime:0.023781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935351000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.036614s ]
SELECT `id` FROM `stock` WHERE `id` <> 55371757 AND `partno` = '1935351000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.023572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14691610 [ RunTime:0.092011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53757395 LIMIT 5 [ RunTime:0.057599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53757395 ORDER BY `minOrder` ASC [ RunTime:0.047734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53757395 ORDER BY `unit` DESC [ RunTime:0.021803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53757395 LIMIT 2 [ RunTime:0.037634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53757395 ORDER BY `minOrder` ASC [ RunTime:0.031744s ]
select * from pdf where partno='1935381' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.035446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1935381' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.041081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53539671 LIMIT 5 [ RunTime:0.063004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539671 ORDER BY `minOrder` ASC [ RunTime:0.040633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53539671 ORDER BY `unit` DESC [ RunTime:0.014069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53539671 LIMIT 2 [ RunTime:0.043150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53539671 ORDER BY `minOrder` ASC [ RunTime:0.004391s ]
select * from pdf where partno='193534-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.042559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '193534-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033206s ]
SELECT `id` FROM `stock` WHERE `id` <> 53539671 AND `partno` = '193534-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.025351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578113 [ RunTime:0.018339s ]
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 '19353%' OR `brand` LIKE '19353%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029339s ]
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 '19353%' OR `brand` LIKE '19353%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043552s ]
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 '19353%' OR `brand` LIKE '19353%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057476s ]
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 '19353%' OR `brand` LIKE '19353%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040849s ]
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 '19353%' OR `brand` LIKE '19353%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028337s ]
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 '19353%' OR `brand` LIKE '19353%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019916s ]
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 '19353%' OR `brand` LIKE '19353%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018076s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19353%' OR `brand` LIKE '19353%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.038246s ]