SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524748 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524748 [ RunTime:0.002391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599842,66116,7919,933944,79260,568088,1009111,168369,869681,203438,545022,590233,277279,526147,984034,1031916,667277,184580,588300,362715,489150,712997,219852,852059,25763,731157,670583,229692,999684,183256,1099,185506,284212,552038,931543,616319,261712,336332,152163,650489,13610,209666,605366,137010,654483,756381,1032540,389047,104844,282955,947168,721397,489276,277208,1043077,822203,282217,465731,221984,864863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]