SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409495 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409495 [ RunTime:0.003295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98668,545554,845670,188419,370642,585202,962416,903120,856590,989942,617293,853151,644633,260650,826481,28308,190159,356463,574131,952871,435626,165256,94562,43549,402895,193335,671240,120684,1017757,730859,216375,538613,141473,697145,879065,967488,548409,735664,692363,249360,618235,1038757,1026163,502871,290355,745569,628603,213085,62388,158912,943257,254442,111810,335166,1009824,295920,863267,261983,949987,373524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]