SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418993 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418993 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675386,6725,1020804,405798,460221,471981,484262,221924,441232,611199,284535,54885,797787,591722,944307,112090,759791,971941,495445,650273,912936,705274,282831,888936,608107,70499,540580,958041,98927,580294,1002805,296476,682097,494557,719061,59132,495943,289172,927038,18212,473600,764960,103602,778127,96305,988068,783126,1009106,443293,770721,749376,647037,790797,591251,959562,585715,746017,72305,302374,492519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]