SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135841,407318,855799,64654,674426,811077,351781,780426,369664,449826,322668,514683,163966,250614,885856,799689,856911,324343,858796,132766,803511,987062,219913,11652,96506,70008,1028264,1045035,673072,738184,408932,713733,648474,345491,486656,759825,648041,1031368,724442,985336,762083,685303,396404,233994,836952,337241,69817,597543,878459,400132,426288,552658,1037265,121144,410033,668408,549694,391572,251422,268335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000893s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]