SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002054s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577812 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577812 [ RunTime:0.012435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104318,48873,1012319,61244,568806,744227,530114,985727,510667,611465,878116,550332,1041149,1003153,335938,596673,159247,305167,474029,121347,553771,980913,689227,884270,765476,98407,890916,1010061,955109,1006992,415453,261422,452451,169555,5121,683997,61647,937881,431583,470513,965076,655740,187755,540204,902620,235267,338730,114529,220593,980748,895293,179732,216097,165150,379472,852318,263658,854680,902764,963742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]