SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455352 LIMIT 1 [ RunTime:0.000636s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455352 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133934,691242,750579,79216,443871,976222,118468,625525,642217,809909,552707,611077,645537,72244,826049,575045,41782,72399,282038,345432,58033,493186,108058,399138,282050,250260,687235,136844,199445,436288,420447,149017,299099,846017,146593,558203,575328,408362,135338,358745,718874,575630,164505,477371,668156,252707,519510,17969,162827,112781,436626,723964,909561,157166,27909,707990,150711,781005,950735,175052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]