SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971610 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971610 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809939,787801,613339,1011270,759662,502394,561030,529069,133156,292452,824645,323415,927166,640561,243810,837645,419640,401855,11803,830044,789129,758311,827388,983201,880786,405969,605486,779731,234372,904912,1000464,714828,967349,357345,522391,946561,883218,151592,232423,33430,850418,34449,711759,1621,138957,917873,9050,760235,769660,598299,234901,961974,106185,325092,138011,712127,61075,586022,488590,134773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]