SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465238 LIMIT 1 [ RunTime:0.000710s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465238 [ RunTime:0.002807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382421,137371,259244,220534,697269,672987,121436,527514,213492,971340,936075,175110,528594,491033,702448,706103,148752,180760,188402,152317,249422,1025379,932161,299267,723173,354432,912928,720267,739199,589455,915118,383280,247354,193303,260806,547928,210373,67849,99604,818009,799066,597749,689834,786940,129444,741170,152638,1036866,197458,525548,1011778,714961,643614,363397,573462,419898,12936,375554,21149,196514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]