SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510231 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510231 [ RunTime:0.003606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15075,533022,436963,885381,444670,579580,895543,571926,40525,570507,625531,347836,356188,29326,119968,101002,89769,118622,297291,496693,962352,1009698,921297,805030,724817,539749,509319,791909,453250,507825,519435,960913,46512,541367,532140,709077,183051,596235,327435,763399,442016,909873,847058,769259,568960,329506,507206,923096,118007,392280,538270,90240,617798,939281,70222,34598,63302,957272,583706,788542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001030s ]