SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038137 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038137 [ RunTime:0.003415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660576,863241,398871,1034410,299537,148888,815132,463459,672857,338442,7588,185757,775473,668446,102097,822254,73094,661454,481288,959138,220808,280804,375903,1024815,162362,137892,1020712,1041285,742257,189433,405223,327262,40917,1045026,831457,940575,891191,340686,792246,638598,430384,882773,595820,879037,852188,897173,525744,509748,862036,815828,297066,186052,21412,825539,451136,831525,483761,839346,1029567,443759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038137 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038137 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]