SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415724 LIMIT 1 [ RunTime:0.000616s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415724 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271537,586323,775193,1005616,142323,942008,34099,946961,884145,987036,299427,329667,118849,743604,518015,944615,759529,497751,113120,110716,999999,1021645,443794,198598,416744,176746,817076,213262,705342,931961,763453,270891,536162,381450,727011,85437,464983,708799,318155,740806,407509,30818,1036957,234083,743239,65944,656804,1021670,431664,402974,773867,129208,15803,841703,941267,967504,375532,134583,252791,732819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415724 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415724 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]