SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539713 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539713 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751692,497184,39313,313784,217329,649143,83309,697226,990596,935529,705332,247487,178380,770268,611066,675232,408915,1046990,818330,119809,840380,813584,162638,509052,6377,84620,836979,30806,656313,864558,1025756,229609,69595,335519,139202,684929,737346,85424,559542,352624,976787,870805,214303,316460,864973,975192,618047,643797,171916,864787,399141,465655,872052,253974,742922,164140,214846,100528,311007,347566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]