SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424821 LIMIT 1 [ RunTime:0.000952s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424821 [ RunTime:0.002808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782382,346879,975455,387613,377266,429545,361908,256705,147269,912043,899917,1039679,263909,953832,357015,440067,802310,915156,611193,280043,463692,894166,848116,340593,751044,689438,484586,677061,38021,864384,818886,983299,648076,914986,939474,719183,595969,1006074,600566,410687,730101,653320,44527,888934,575217,540387,619884,84476,65270,714048,374088,695542,936629,19591,438197,713387,58638,418016,829346,864716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]