SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468331 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468331 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657555,339881,614184,47697,334311,1017288,842505,786851,355296,221378,1034815,1014071,718327,233631,205255,207568,640002,324656,943585,58172,28891,161125,345760,151292,271018,123495,258524,4871,253490,15313,864344,559444,555018,131331,931906,1004609,831776,625900,848460,955854,797999,954597,357450,792438,54540,996221,559261,987781,550360,524402,33098,429147,383245,774292,502061,731898,996205,814298,781714,1022972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]