SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681391 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681391 [ RunTime:0.002343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214299,560192,9625,1768,40234,808381,226562,50546,1011276,455424,757468,350438,239745,516217,952927,806229,99913,464320,1022507,114750,146413,89541,206102,877165,979055,683584,605175,815075,237691,229493,17540,934475,563314,984992,996303,1041166,510178,384500,652415,389887,530356,862237,91755,597833,49907,732816,31271,1046993,281306,116559,436557,45380,630949,662744,164892,407425,929201,720738,721647,800807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]