SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503711 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503711 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534528,929678,907670,380620,283076,728738,728401,765230,691687,439863,67255,202741,997731,97616,120687,388274,500702,147085,203374,647828,161664,9799,846466,783041,165623,151684,313133,625236,68202,744439,966685,518177,664067,430819,1042621,710218,129615,707113,975303,652651,352985,430769,27703,783705,787660,410216,1016271,835546,333834,29385,357227,509556,1048433,1012664,183741,595014,863435,487010,665093,927899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]