SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011581 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011581 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333855,911507,1048816,617776,351818,500243,934664,1025661,283377,43666,158005,53960,949960,389395,578998,98387,605638,730094,870024,1041147,997856,264517,480543,437017,393736,987759,1026037,90755,709154,903688,153847,776897,690124,443059,79474,766877,503555,898778,856053,718133,89555,5566,426615,392662,666688,219379,864569,667592,852661,24602,386125,649063,287076,734714,1016749,720515,644333,220648,138249,27973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]