SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004454s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484480 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484480 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979241,912061,359989,557504,454733,643408,120064,56944,976723,677136,843748,756093,218937,161499,603438,820638,656068,161062,289302,661160,1003888,394300,993110,996431,1012222,786625,127994,699305,451549,1033469,536165,879964,274590,62351,279048,1021897,1003622,353508,213328,184707,193439,252775,828629,233396,565527,806755,880418,321911,976156,932611,502836,191455,766531,688854,310733,1039262,893381,213105,636246,951225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]