SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841707 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841707 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412742,611440,572410,851042,561342,566005,835345,584488,69383,338597,977261,182598,301032,464136,348650,271487,580579,39388,678507,596941,830635,438033,95661,929282,803633,386748,272787,664241,623952,471656,972396,987121,394866,69018,307781,532810,181541,967192,486921,545048,452056,826330,815511,146636,114727,949164,500077,927060,254394,10842,791706,419916,961608,602326,734293,74932,619414,596850,134884,368084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]