SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41719 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41719 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417977,221579,393257,19774,312616,45480,1003283,1014315,441129,627008,167686,959982,1043858,573483,902460,585821,678379,256197,852044,912945,214144,587697,355583,100904,699803,762511,591816,924136,834696,692429,869130,35141,365329,542132,40189,460656,267347,399465,244274,773174,783210,345258,196036,204944,232751,100482,291872,838696,31693,866549,788355,43835,885563,416303,838998,493444,96707,386441,217522,226509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41719 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41719 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001463s ]