SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496622 LIMIT 1 [ RunTime:0.001606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496622 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523661,325347,382902,25925,341861,700151,967303,396535,929094,198029,190363,847432,1035072,390463,422335,26534,744612,663220,978505,658153,80182,949724,698412,731384,226062,276627,617195,939802,720706,303624,506552,913411,859139,391501,314680,712564,249175,744049,900515,826213,879921,290681,1044282,289378,404955,409584,724589,932631,647985,702929,769011,348393,988920,891326,462242,51100,975885,915986,646725,884435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]