SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10987 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10987 [ RunTime:0.002649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19764,750431,1008495,929606,357613,106164,804903,765954,624751,93752,532463,587537,823617,902320,482115,293629,401791,74599,631072,951545,31831,678453,866273,733890,902491,153633,173365,444467,77936,855705,926534,748741,94823,262059,309460,301649,637882,111313,926224,879660,382982,617795,655571,50222,425341,647762,514073,842761,100195,180694,853744,37193,715156,552995,710830,213546,95327,201856,458360,722378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]