SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506799 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506799 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197161,691687,621315,14296,111023,907430,479102,614597,982764,135757,114196,659374,843671,549477,568181,120595,683219,16265,525217,796587,818946,780189,426483,92958,724032,939141,567052,859924,1001337,698859,869970,979875,13254,532424,960897,919135,277574,945471,620126,315695,497015,157019,699673,854899,579983,398453,253867,570837,64226,945404,254904,1011063,240285,845203,545138,159218,1001065,625691,7907,755765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]