SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523481 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523481 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87189,960205,109323,1043223,890296,433214,557554,995623,121018,27062,482255,368006,623624,35045,723151,252664,1004084,1022422,325922,849736,678970,408305,326015,205451,638009,614187,650509,251734,435567,756549,282517,705353,354212,869535,320984,442247,36050,156739,505670,815407,475806,477838,594568,497693,616782,507011,758510,52288,144958,798092,314537,578224,42147,94834,1044181,901904,634650,393739,517856,619725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]