SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564913 LIMIT 1 [ RunTime:0.001105s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564913 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839075,446139,659587,502710,391259,75955,1018472,705142,418307,395090,307402,587789,211249,783619,630474,468247,840340,979428,178531,470495,120629,797634,302272,743119,627706,234401,541455,271843,196106,424965,494947,456351,135087,536965,827348,995333,5832,46901,966396,902896,977641,309143,277191,768581,1010624,570983,272802,867315,805039,725570,96096,859093,297393,847679,579909,860207,579527,708483,149514,30078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]