SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541118 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541118 [ RunTime:0.001416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300593,431492,265028,973625,239602,412945,187051,966612,51880,918644,334745,360118,826461,592998,288772,644985,135691,144593,790963,358443,636189,134592,353,127748,1048189,732850,525089,6922,738538,1008583,467189,668578,1025247,95920,725868,1004687,238308,449715,1018894,542889,551964,80894,528855,722316,570383,129252,1023542,954209,243390,459378,671995,637472,812362,185032,210282,643130,535744,44145,237158,308626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]