SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 992017 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 992017 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856831,15658,154046,331933,601257,410176,195989,19131,964511,792077,84954,474308,753058,244052,93770,688170,210257,71366,261879,124353,631315,902025,783042,456131,683278,565648,457866,923329,419194,670619,894235,767599,15941,66863,201043,683995,506076,1027151,473837,856515,992426,27281,835295,481300,763168,595810,501118,984115,551033,829938,80956,304739,123613,559132,452739,982040,715051,831465,489152,265520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 992017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 992017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]