SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037102 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037102 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412176,810629,429934,918171,1000770,501640,840998,851336,106573,374674,450544,409610,193846,84305,357997,594710,498035,125573,203126,650571,526595,606096,18335,515276,717341,952676,554191,157839,513066,453104,298367,256776,532926,941565,1042294,966896,536251,493142,33587,822226,52883,772070,579490,236157,61888,444515,784380,987276,135258,828740,205676,830978,229277,967585,406225,935008,137171,949235,663414,339003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]