SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293913 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293913 [ RunTime:0.004118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676274,423647,968475,846654,732662,70232,991598,318972,542773,400800,1046817,543572,163358,226567,286772,941875,646706,896444,724718,247874,509062,687587,580362,525319,53607,231610,830942,40686,188502,493913,296599,1024789,748619,832476,421261,307270,183201,535225,175021,915324,532611,475367,745077,441438,281957,275270,465509,356541,428121,452300,512313,646561,1026236,54086,212267,236365,452922,445019,82359,626923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]