SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337043 LIMIT 1 [ RunTime:0.000611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337043 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006601,419392,648222,569465,762570,843690,944901,127581,192619,414253,680542,345671,339621,734787,942301,819816,350444,1042130,857204,684445,891285,705450,72116,46421,492399,667082,39337,939890,222458,824521,819930,38872,757224,217096,867947,791129,995896,136534,335263,885302,249532,139932,98232,25004,960848,994360,343838,588247,121009,369944,235628,522173,1040849,236732,898439,415666,982388,1034065,364555,336117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]