SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548711 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548711 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303023,552476,813194,361902,622936,203476,403191,678955,765102,551070,970471,660301,369203,79382,227305,93353,477362,194099,756504,997158,600944,451253,667638,1010937,70738,44750,933782,406021,893545,763003,942277,110595,1043678,231739,164349,379566,182461,64518,529244,223079,298229,730605,877615,821328,408225,154030,436995,1023665,710371,839599,1021303,208196,694229,482782,91023,635411,22698,316299,539529,650716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]