SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017069 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017069 [ RunTime:0.003081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527961,701785,676801,591809,741567,157831,157089,934345,519797,225860,189763,131140,858689,146824,868588,36711,448242,660341,862874,518015,398318,311550,1021742,496658,399055,84231,470174,905483,593669,615083,228315,294543,670199,128962,1026109,531475,16104,750993,637486,270744,873051,465835,11369,40200,780091,246024,137379,1022353,570340,30527,556614,365774,226344,331567,571335,1030243,859467,970913,211591,560076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000790s ]