SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 771998 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 771998 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263842,1033235,371178,964034,256025,75480,491085,860698,166240,176292,550322,1001158,28374,248826,463683,586025,892278,49647,211360,402999,395463,288521,242457,1030926,163028,318731,582933,462982,60101,834407,424818,314549,448915,1005581,463279,368441,401169,787321,733425,873892,509774,1003754,880702,136109,708047,657644,341960,910570,486593,582343,191780,114834,302655,1010104,232408,606988,848351,373769,178669,40498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 771998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 771998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]