SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506358 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506358 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772211,663874,77987,939287,919436,276329,883420,549230,654540,100537,947134,429595,784953,462307,408429,177089,37312,569628,6861,629801,853498,431203,881551,423587,7455,585071,878556,918953,281387,97477,571976,231486,267153,596947,165256,910474,216519,847583,818246,296805,325600,501827,968888,475340,54632,839465,273149,249689,886414,255601,163285,939221,300925,543919,241433,7084,830492,926126,17848,292675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]