SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544328 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544328 [ RunTime:0.001451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723095,559148,546184,749916,978126,1032610,317270,715183,659232,212396,28738,344665,617013,307180,806979,100886,828116,783649,432496,907073,170046,500562,928496,828974,780241,775473,276460,447665,73031,53980,221008,423493,162965,866911,1001971,326669,954830,843475,29341,846523,947307,547215,616932,677388,617289,370654,537178,868582,459282,887330,713287,22098,423553,891050,296220,485294,141866,1038796,97557,600860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]