SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508848 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508848 [ RunTime:0.002145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453970,685995,317045,697118,154244,207135,175917,131355,746278,63974,176857,527853,238932,330544,927612,981301,487453,459729,962159,494703,1044819,789580,708055,160798,172463,888734,427100,452725,81394,746411,478137,826846,967871,134135,275529,1000663,271477,889032,1042022,486691,30842,1018863,664589,135617,247769,190453,413203,997186,1013711,294822,1012264,22731,234954,70785,134642,749517,512320,809067,622782,656161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]