SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910762 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910762 [ RunTime:0.004284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013948,1013495,205707,508297,408395,36595,393108,567109,870330,199135,393332,892862,573881,723675,723228,801401,749955,801230,333279,214888,1013215,544915,574021,141652,66691,491193,811562,380000,1597,292542,297371,876465,1042241,151810,888765,985309,691258,5289,263027,437672,616007,1033964,70054,485285,478213,862846,765768,897013,546055,648559,137099,587572,1019821,1033489,228685,811760,92407,67439,630975,142542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]