SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 247063 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 247063 [ RunTime:0.005200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598654,561090,537602,286511,41729,630786,17455,801680,673197,797540,1034530,207868,799207,1029752,787570,1002361,72489,191689,258626,331722,1006439,255484,328920,564008,378584,115360,486519,343149,736105,369322,441394,636795,660081,683546,3715,412211,96474,660173,150647,529103,815104,644449,142201,200413,530302,2156,97349,801444,431310,565939,119729,205027,338900,523724,484798,839087,833454,446175,327332,722343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 247063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 247063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]