SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510063 LIMIT 1 [ RunTime:0.000848s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510063 [ RunTime:0.003576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164244,165359,891013,908792,64566,660863,747314,262373,498337,84762,384177,94473,385953,407232,620807,667491,346081,935581,893876,198492,336623,791873,474439,55601,1009037,1026127,85340,426378,758900,975334,883898,886716,902774,10235,922110,468000,302916,100592,499677,109124,194937,578559,970685,914713,537277,519846,997008,973165,506871,520280,546372,611896,338702,385507,770203,784146,446470,981345,492657,628816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]