SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004734s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417588 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417588 [ RunTime:0.003156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020288,803887,447242,779110,837704,44732,874272,161055,327254,922433,963323,914795,652763,554879,514329,283520,941378,264026,208902,644514,515258,392474,336268,528975,1043844,66122,385140,975176,98746,714882,258586,996243,256510,572213,562890,951103,540351,286205,930179,782383,1015270,658681,673408,546284,960476,294763,608047,908947,336673,342179,844137,940400,520104,25202,789813,234625,834551,240663,68936,418729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]