SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453152 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453152 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280787,193888,1039472,478267,687084,839448,897770,162851,216392,275699,942999,705718,511159,772146,802410,812728,62463,711191,1008833,123934,76520,707508,1038954,921314,734804,805736,545679,859535,405500,720027,270633,740317,536803,262715,21047,336980,943496,701546,843386,356004,786385,985841,167830,68384,224575,83871,331652,172787,385517,230983,748066,1026201,748723,13121,1004106,635876,296777,921161,1001669,891253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]