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` = 1034986 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034986 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457368,686440,549887,532326,132010,878457,623342,957014,362562,165141,347772,380374,284757,226943,510048,776368,995074,159094,311602,286327,757365,21415,35729,733507,112155,371993,475777,142071,217830,344089,135155,846184,290334,219170,815348,856151,729652,562552,830267,716325,762671,801338,253583,168699,102104,447045,733759,567857,871175,681917,908544,606264,664229,919657,297739,1023985,177337,560116,323344,742364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]