SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002408s ]
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 '2755%' OR `brand` LIKE '2755%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036102s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.041788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166312 LIMIT 5 [ RunTime:0.029724s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12166312 ORDER BY `minOrder` ASC [ RunTime:0.025570s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12166312 ORDER BY `unit` DESC [ RunTime:0.044754s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12166312 LIMIT 2 [ RunTime:0.048070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12166312 ORDER BY `minOrder` ASC [ RunTime:0.020196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11183531 LIMIT 5 [ RunTime:0.032477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11183531 ORDER BY `minOrder` ASC [ RunTime:0.021469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11183531 ORDER BY `unit` DESC [ RunTime:0.068438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11183531 LIMIT 2 [ RunTime:0.047842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11183531 ORDER BY `minOrder` ASC [ RunTime:0.069097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166985 LIMIT 5 [ RunTime:0.020673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12166985 ORDER BY `minOrder` ASC [ RunTime:0.060636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12166985 ORDER BY `unit` DESC [ RunTime:0.062395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12166985 LIMIT 2 [ RunTime:0.022685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12166985 ORDER BY `minOrder` ASC [ RunTime:0.041107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14357330 LIMIT 5 [ RunTime:0.031636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14357330 ORDER BY `minOrder` ASC [ RunTime:0.029030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14357330 ORDER BY `unit` DESC [ RunTime:0.023584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14357330 LIMIT 2 [ RunTime:0.071193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14357330 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346959 LIMIT 5 [ RunTime:0.033709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346959 ORDER BY `minOrder` ASC [ RunTime:0.030182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346959 ORDER BY `unit` DESC [ RunTime:0.029262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346959 LIMIT 2 [ RunTime:0.014226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346959 ORDER BY `minOrder` ASC [ RunTime:0.005683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12167025 LIMIT 5 [ RunTime:0.024958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12167025 ORDER BY `minOrder` ASC [ RunTime:0.024772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12167025 ORDER BY `unit` DESC [ RunTime:0.023162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12167025 LIMIT 2 [ RunTime:0.005832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12167025 ORDER BY `minOrder` ASC [ RunTime:0.001588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12167042 LIMIT 5 [ RunTime:0.001727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12167042 ORDER BY `minOrder` ASC [ RunTime:0.001597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12167042 ORDER BY `unit` DESC [ RunTime:0.004216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12167042 LIMIT 2 [ RunTime:0.015190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12167042 ORDER BY `minOrder` ASC [ RunTime:0.002577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14198151 LIMIT 5 [ RunTime:0.011127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14198151 ORDER BY `minOrder` ASC [ RunTime:0.011524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14198151 ORDER BY `unit` DESC [ RunTime:0.026765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14198151 LIMIT 2 [ RunTime:0.021233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14198151 ORDER BY `minOrder` ASC [ RunTime:0.001452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19646371 LIMIT 5 [ RunTime:0.027705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646371 ORDER BY `minOrder` ASC [ RunTime:0.029434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19646371 ORDER BY `unit` DESC [ RunTime:0.006152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19646371 LIMIT 2 [ RunTime:0.002562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646371 ORDER BY `minOrder` ASC [ RunTime:0.003925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19646370 LIMIT 5 [ RunTime:0.002842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646370 ORDER BY `minOrder` ASC [ RunTime:0.007909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19646370 ORDER BY `unit` DESC [ RunTime:0.003946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19646370 LIMIT 2 [ RunTime:0.008314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646370 ORDER BY `minOrder` ASC [ RunTime:0.003805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19646369 LIMIT 5 [ RunTime:0.006333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646369 ORDER BY `minOrder` ASC [ RunTime:0.005518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19646369 ORDER BY `unit` DESC [ RunTime:0.001889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19646369 LIMIT 2 [ RunTime:0.007332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646369 ORDER BY `minOrder` ASC [ RunTime:0.001894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19646368 LIMIT 5 [ RunTime:0.011229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646368 ORDER BY `minOrder` ASC [ RunTime:0.009875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19646368 ORDER BY `unit` DESC [ RunTime:0.005594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19646368 LIMIT 2 [ RunTime:0.007919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646368 ORDER BY `minOrder` ASC [ RunTime:0.005037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19645993 LIMIT 5 [ RunTime:0.001487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645993 ORDER BY `minOrder` ASC [ RunTime:0.004389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19645993 ORDER BY `unit` DESC [ RunTime:0.001060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19645993 LIMIT 2 [ RunTime:0.003567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645993 ORDER BY `minOrder` ASC [ RunTime:0.003146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19640261 LIMIT 5 [ RunTime:0.001073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19640261 ORDER BY `minOrder` ASC [ RunTime:0.001446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19640261 ORDER BY `unit` DESC [ RunTime:0.009619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19640261 LIMIT 2 [ RunTime:0.008752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19640261 ORDER BY `minOrder` ASC [ RunTime:0.013369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19639531 LIMIT 5 [ RunTime:0.012243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639531 ORDER BY `minOrder` ASC [ RunTime:0.010061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19639531 ORDER BY `unit` DESC [ RunTime:0.003379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19639531 LIMIT 2 [ RunTime:0.029165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639531 ORDER BY `minOrder` ASC [ RunTime:0.018569s ]
select * from pdf where partno='2755210000' and brandshort='Weidmüller' limit 1 [ RunTime:0.016633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19639018 LIMIT 5 [ RunTime:0.033540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639018 ORDER BY `minOrder` ASC [ RunTime:0.010138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19639018 ORDER BY `unit` DESC [ RunTime:0.012064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19639018 LIMIT 2 [ RunTime:0.009953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639018 ORDER BY `minOrder` ASC [ RunTime:0.003051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638902 LIMIT 5 [ RunTime:0.011174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638902 ORDER BY `minOrder` ASC [ RunTime:0.010410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638902 ORDER BY `unit` DESC [ RunTime:0.003586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638902 LIMIT 2 [ RunTime:0.014335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638902 ORDER BY `minOrder` ASC [ RunTime:0.002137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638901 LIMIT 5 [ RunTime:0.005976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638901 ORDER BY `minOrder` ASC [ RunTime:0.001746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638901 ORDER BY `unit` DESC [ RunTime:0.007161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638901 LIMIT 2 [ RunTime:0.015534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638901 ORDER BY `minOrder` ASC [ RunTime:0.006247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638900 LIMIT 5 [ RunTime:0.007803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638900 ORDER BY `minOrder` ASC [ RunTime:0.007082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638900 ORDER BY `unit` DESC [ RunTime:0.004859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638900 LIMIT 2 [ RunTime:0.011149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638900 ORDER BY `minOrder` ASC [ RunTime:0.002731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638899 LIMIT 5 [ RunTime:0.008789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638899 ORDER BY `minOrder` ASC [ RunTime:0.025255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638899 ORDER BY `unit` DESC [ RunTime:0.013468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638899 LIMIT 2 [ RunTime:0.011199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638899 ORDER BY `minOrder` ASC [ RunTime:0.004247s ]
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 '2755%' OR `brand` LIKE '2755%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011074s ]
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 '2755%' OR `brand` LIKE '2755%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57745176 LIMIT 5 [ RunTime:0.019157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57745176 ORDER BY `minOrder` ASC [ RunTime:0.017495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57745176 ORDER BY `unit` DESC [ RunTime:0.031799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57745176 LIMIT 2 [ RunTime:0.008193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57745176 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='2755CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004894s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013595s ]
SELECT `id` FROM `stock` WHERE `id` <> 57745176 AND `partno` = '2755CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.022076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346959 [ RunTime:0.013992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51699256 LIMIT 5 [ RunTime:0.007744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699256 ORDER BY `minOrder` ASC [ RunTime:0.014533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51699256 ORDER BY `unit` DESC [ RunTime:0.013871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51699256 LIMIT 2 [ RunTime:0.014861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699256 ORDER BY `minOrder` ASC [ RunTime:0.044511s ]
select * from pdf where partno='27553' and brandshort='Wiha' limit 1 [ RunTime:0.034110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27553' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.002919s ]
SELECT `id` FROM `stock` WHERE `id` <> 51699256 AND `partno` = '27553' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.011146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166985 [ RunTime:0.001101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51699260 LIMIT 5 [ RunTime:0.007757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699260 ORDER BY `minOrder` ASC [ RunTime:0.008159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51699260 ORDER BY `unit` DESC [ RunTime:0.045816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51699260 LIMIT 2 [ RunTime:0.021945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699260 ORDER BY `minOrder` ASC [ RunTime:0.007613s ]
select * from pdf where partno='27552' and brandshort='Wiha' limit 1 [ RunTime:0.027141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27552' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.007083s ]
SELECT `id` FROM `stock` WHERE `id` <> 51699260 AND `partno` = '27552' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.026002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11183531 [ RunTime:0.034612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51699359 LIMIT 5 [ RunTime:0.005417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699359 ORDER BY `minOrder` ASC [ RunTime:0.017135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51699359 ORDER BY `unit` DESC [ RunTime:0.006636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51699359 LIMIT 2 [ RunTime:0.021942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699359 ORDER BY `minOrder` ASC [ RunTime:0.014887s ]
select * from pdf where partno='27554' and brandshort='Wiha' limit 1 [ RunTime:0.012192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27554' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.028555s ]
SELECT `id` FROM `stock` WHERE `id` <> 51699359 AND `partno` = '27554' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.004235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51422544 LIMIT 5 [ RunTime:0.004007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51422544 ORDER BY `minOrder` ASC [ RunTime:0.014095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51422544 ORDER BY `unit` DESC [ RunTime:0.006310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51422544 LIMIT 2 [ RunTime:0.012410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51422544 ORDER BY `minOrder` ASC [ RunTime:0.004974s ]
select * from pdf where partno='2755' and brandshort='Pololu' limit 1 [ RunTime:0.002699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.016027s ]
SELECT `id` FROM `stock` WHERE `id` <> 51422544 AND `partno` = '2755' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.009018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14357330 [ RunTime:0.014963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51699432 LIMIT 5 [ RunTime:0.016689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699432 ORDER BY `minOrder` ASC [ RunTime:0.027029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51699432 ORDER BY `unit` DESC [ RunTime:0.011096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51699432 LIMIT 2 [ RunTime:0.013091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699432 ORDER BY `minOrder` ASC [ RunTime:0.006972s ]
select * from pdf where partno='27558' and brandshort='Wiha' limit 1 [ RunTime:0.055603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27558' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.031569s ]
SELECT `id` FROM `stock` WHERE `id` <> 51699432 AND `partno` = '27558' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.021791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166312 [ RunTime:0.039812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51870438 LIMIT 5 [ RunTime:0.031462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51870438 ORDER BY `minOrder` ASC [ RunTime:0.046815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51870438 ORDER BY `unit` DESC [ RunTime:0.013815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51870438 LIMIT 2 [ RunTime:0.017783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51870438 ORDER BY `minOrder` ASC [ RunTime:0.010179s ]
select * from pdf where partno='2755910000' and brandshort='Weidmüller' limit 1 [ RunTime:0.016696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755910000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.031582s ]
SELECT `id` FROM `stock` WHERE `id` <> 51870438 AND `partno` = '2755910000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.020120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51699641 LIMIT 5 [ RunTime:0.011564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699641 ORDER BY `minOrder` ASC [ RunTime:0.040948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51699641 ORDER BY `unit` DESC [ RunTime:0.010946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51699641 LIMIT 2 [ RunTime:0.005982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699641 ORDER BY `minOrder` ASC [ RunTime:0.004043s ]
select * from pdf where partno='27557' and brandshort='Wiha' limit 1 [ RunTime:0.024226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27557' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.016618s ]
SELECT `id` FROM `stock` WHERE `id` <> 51699641 AND `partno` = '27557' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.039785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12167025 [ RunTime:0.022389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51699959 LIMIT 5 [ RunTime:0.032335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699959 ORDER BY `minOrder` ASC [ RunTime:0.031833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51699959 ORDER BY `unit` DESC [ RunTime:0.033331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51699959 LIMIT 2 [ RunTime:0.012980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699959 ORDER BY `minOrder` ASC [ RunTime:0.006858s ]
select * from pdf where partno='27555' and brandshort='Wiha' limit 1 [ RunTime:0.023962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27555' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.016536s ]
SELECT `id` FROM `stock` WHERE `id` <> 51699959 AND `partno` = '27555' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.011328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51699678 LIMIT 5 [ RunTime:0.013555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699678 ORDER BY `minOrder` ASC [ RunTime:0.021972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51699678 ORDER BY `unit` DESC [ RunTime:0.028069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51699678 LIMIT 2 [ RunTime:0.029284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51699678 ORDER BY `minOrder` ASC [ RunTime:0.006440s ]
select * from pdf where partno='27551' and brandshort='Wiha' limit 1 [ RunTime:0.015958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27551' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.020791s ]
SELECT `id` FROM `stock` WHERE `id` <> 51699678 AND `partno` = '27551' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.023994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12167042 [ RunTime:0.011263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57683191 LIMIT 5 [ RunTime:0.016842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57683191 ORDER BY `minOrder` ASC [ RunTime:0.016319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57683191 ORDER BY `unit` DESC [ RunTime:0.016672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57683191 LIMIT 2 [ RunTime:0.026988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57683191 ORDER BY `minOrder` ASC [ RunTime:0.020776s ]
select * from pdf where partno='2755' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.024462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.010090s ]
SELECT `id` FROM `stock` WHERE `id` <> 57683191 AND `partno` = '2755' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.025534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352799 [ RunTime:0.019315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57477759 LIMIT 5 [ RunTime:0.019571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57477759 ORDER BY `minOrder` ASC [ RunTime:0.025956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57477759 ORDER BY `unit` DESC [ RunTime:0.040269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57477759 LIMIT 2 [ RunTime:0.038370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57477759 ORDER BY `minOrder` ASC [ RunTime:0.015949s ]
select * from pdf where partno='2755290' and brandshort='LOCTITE' limit 1 [ RunTime:0.025168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755290' OR `brand` LIKE 'LOCTITE%' ) ) LIMIT 1 [ RunTime:0.039630s ]
SELECT `id` FROM `stock` WHERE `id` <> 57477759 AND `partno` = '2755290' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%loctite%' ) [ RunTime:0.061748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17157685 [ RunTime:0.048390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57310844 LIMIT 5 [ RunTime:0.021460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310844 ORDER BY `minOrder` ASC [ RunTime:0.016381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57310844 ORDER BY `unit` DESC [ RunTime:0.042232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57310844 LIMIT 2 [ RunTime:0.053296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310844 ORDER BY `minOrder` ASC [ RunTime:0.024482s ]
select * from pdf where partno='2755980000' and brandshort='Weidmüller' limit 1 [ RunTime:0.025601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755980000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.024359s ]
SELECT `id` FROM `stock` WHERE `id` <> 57310844 AND `partno` = '2755980000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.035544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57310766 LIMIT 5 [ RunTime:0.054787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310766 ORDER BY `minOrder` ASC [ RunTime:0.035463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57310766 ORDER BY `unit` DESC [ RunTime:0.021304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57310766 LIMIT 2 [ RunTime:0.011399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310766 ORDER BY `minOrder` ASC [ RunTime:0.004236s ]
select * from pdf where partno='2755960000' and brandshort='Weidmüller' limit 1 [ RunTime:0.023786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755960000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010447s ]
SELECT `id` FROM `stock` WHERE `id` <> 57310766 AND `partno` = '2755960000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13358607 [ RunTime:0.010831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57310749 LIMIT 5 [ RunTime:0.027065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310749 ORDER BY `minOrder` ASC [ RunTime:0.040164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57310749 ORDER BY `unit` DESC [ RunTime:0.001739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57310749 LIMIT 2 [ RunTime:0.022569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310749 ORDER BY `minOrder` ASC [ RunTime:0.009577s ]
select * from pdf where partno='2755990000' and brandshort='Weidmüller' limit 1 [ RunTime:0.022368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755990000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010814s ]
SELECT `id` FROM `stock` WHERE `id` <> 57310749 AND `partno` = '2755990000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.033199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12072652 [ RunTime:0.024560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57310720 LIMIT 5 [ RunTime:0.008767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310720 ORDER BY `minOrder` ASC [ RunTime:0.002513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57310720 ORDER BY `unit` DESC [ RunTime:0.008931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57310720 LIMIT 2 [ RunTime:0.026385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310720 ORDER BY `minOrder` ASC [ RunTime:0.009089s ]
select * from pdf where partno='2755970000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755970000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.032780s ]
SELECT `id` FROM `stock` WHERE `id` <> 57310720 AND `partno` = '2755970000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.023528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13358582 [ RunTime:0.010710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57310687 LIMIT 5 [ RunTime:0.010040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310687 ORDER BY `minOrder` ASC [ RunTime:0.034631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57310687 ORDER BY `unit` DESC [ RunTime:0.013756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57310687 LIMIT 2 [ RunTime:0.009950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57310687 ORDER BY `minOrder` ASC [ RunTime:0.017191s ]
select * from pdf where partno='2755950000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755950000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.029576s ]
SELECT `id` FROM `stock` WHERE `id` <> 57310687 AND `partno` = '2755950000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.029457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12072631 [ RunTime:0.004980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56603952 LIMIT 5 [ RunTime:0.021174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56603952 ORDER BY `minOrder` ASC [ RunTime:0.032649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56603952 ORDER BY `unit` DESC [ RunTime:0.022468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56603952 LIMIT 2 [ RunTime:0.022371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56603952 ORDER BY `minOrder` ASC [ RunTime:0.010565s ]
select * from pdf where partno='2755-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.011501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.002679s ]
SELECT `id` FROM `stock` WHERE `id` <> 56603952 AND `partno` = '2755-BLACK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.004491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56603744 LIMIT 5 [ RunTime:0.011821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56603744 ORDER BY `minOrder` ASC [ RunTime:0.002815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56603744 ORDER BY `unit` DESC [ RunTime:0.016213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56603744 LIMIT 2 [ RunTime:0.011550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56603744 ORDER BY `minOrder` ASC [ RunTime:0.005753s ]
select * from pdf where partno='2755' and brandshort='80/20, LLC' limit 1 [ RunTime:0.007464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.011943s ]
SELECT `id` FROM `stock` WHERE `id` <> 56603744 AND `partno` = '2755' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.005585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56577785 LIMIT 5 [ RunTime:0.040628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56577785 ORDER BY `minOrder` ASC [ RunTime:0.021864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56577785 ORDER BY `unit` DESC [ RunTime:0.031053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56577785 LIMIT 2 [ RunTime:0.015869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56577785 ORDER BY `minOrder` ASC [ RunTime:0.028782s ]
select * from pdf where partno='2755' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.098450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2755' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.014587s ]
SELECT `id` FROM `stock` WHERE `id` <> 56577785 AND `partno` = '2755' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.028960s ]
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 '2755%' OR `brand` LIKE '2755%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066170s ]
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 '2755%' OR `brand` LIKE '2755%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037579s ]
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 '2755%' OR `brand` LIKE '2755%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038627s ]
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 '2755%' OR `brand` LIKE '2755%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029897s ]
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 '2755%' OR `brand` LIKE '2755%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026828s ]
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 '2755%' OR `brand` LIKE '2755%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020065s ]
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 '2755%' OR `brand` LIKE '2755%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009339s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2755%' OR `brand` LIKE '2755%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.028856s ]