SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520433 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520433 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004567,1047659,437829,90908,149953,256270,444709,1012944,666053,695814,105094,663477,330123,1007056,960001,566756,832041,974179,852055,535312,385409,30100,570315,295646,927457,34500,948672,316277,663930,232267,543806,107116,89065,912328,1021006,483180,993169,473573,144813,30972,789193,367278,803427,609187,273837,299843,114680,917140,995463,175748,986554,1044963,223049,522309,454349,401367,1017838,544619,859578,695005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]