SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 975940 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 975940 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4481,414978,613083,507352,882102,346631,192486,129191,662353,994630,328715,253744,846808,567057,722180,448235,977920,900164,829094,575320,520843,270672,928725,325901,198183,988948,543845,1042389,52130,904,786112,92972,861626,996220,508624,963950,643001,727331,414755,458904,943181,106854,914665,325900,577567,549331,480302,833551,346381,452439,41384,292406,581019,120981,799013,486784,323565,780616,193554,575535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 975940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 975940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]