SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028201 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028201 [ RunTime:0.002329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327644,947200,1000028,815314,959958,970501,341883,282721,99063,665981,1008846,478372,34444,908350,897103,988091,919071,462741,237158,47740,815502,464922,144783,961855,77687,264624,1481,598047,87448,76460,589721,947312,800136,893627,445939,976592,369346,915696,294367,244647,965182,847697,747418,223552,717882,253740,249144,774745,667890,966450,709518,453667,397463,656300,586389,680089,386679,924345,856286,424169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001576s ]