SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570860 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570860 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808036,155987,48406,275453,70843,869988,422912,119145,1030863,681894,190941,474159,518241,185491,644670,354752,896760,476428,955345,237044,246876,201123,153176,1022737,742898,100780,510117,451625,1026474,951501,184396,568119,75703,221133,1005075,544153,788475,770818,564986,434312,365297,75209,842085,651967,449657,588984,813049,897665,831152,129015,770205,635011,286833,240848,15503,91904,897551,315940,7435,243614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]