SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020880 LIMIT 1 [ RunTime:0.000976s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020880 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172455,61988,749519,58859,171633,28342,907454,268674,552891,270291,816895,199908,557462,888505,225298,735885,843869,84492,267224,120607,628359,689768,821487,954089,504618,235830,290613,942352,343387,503720,264601,719357,401389,931166,813112,145379,722618,325632,340089,499034,403951,706823,215679,307921,152659,463554,583673,984682,1041648,210844,661285,806012,33938,924652,300358,34548,752747,375788,1032489,249249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]