SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173013 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173013 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528273,5401,1038241,948821,66737,713442,487928,56859,250701,531591,107552,986088,816455,366434,326264,426516,842119,69755,78755,767088,578810,659392,239582,916228,295062,83285,89102,877190,291043,821645,39135,56426,594331,241169,929776,278040,91044,97792,696710,1002650,132769,125661,604933,967702,575253,677100,909031,507909,483677,675817,34378,314472,559923,695334,15050,898784,30989,379921,982496,352533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]