SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542585 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542585 [ RunTime:0.002915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013785,1038982,954368,443401,127174,825452,106166,248722,642843,653755,1019848,673414,68621,715450,341152,177012,973039,718004,772450,78581,204824,599928,218338,847486,1022332,530214,1017047,742522,480293,494886,134154,12223,521092,193076,930768,367010,385408,302837,320006,660644,68912,84430,161093,649327,436619,447708,452331,487022,686752,376045,343353,60789,237856,336062,70532,844095,429645,440914,177226,633945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]