SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311718 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311718 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270069,648397,176512,564380,634375,754667,519675,495158,458609,454001,334905,833289,250222,371986,791670,439549,219022,219476,200500,1003391,84456,611512,218983,838776,482801,904611,125898,301063,660051,774688,262908,909361,496013,671608,814580,119547,448513,10258,285126,27082,705326,199974,672382,30042,893759,339535,380380,962183,902503,851410,193665,6374,338771,180276,272121,415473,835464,691583,917241,475188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]