SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585161 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585161 [ RunTime:0.002618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570507,1036926,459326,260928,952235,788690,882400,476691,933673,616205,260661,873430,1043834,360804,964597,408324,63191,545292,120888,942999,246510,976634,193000,77407,599386,916861,509718,200151,881073,643463,266123,1022309,150697,1012953,31548,475153,401269,239901,992418,63149,808183,254769,465802,419837,251975,472142,151836,351512,382832,936773,122399,678687,974904,857997,466439,825861,667258,824905,288523,620937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002903s ]