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` = 1017318 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017318 [ RunTime:0.003236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496039,198768,591200,864032,572459,392874,614745,787120,654770,1018444,368455,933995,479181,493883,739062,472583,712231,234434,131608,239442,1039998,157301,132630,25178,585830,1022595,425055,759681,182700,110300,838355,236007,449751,640885,222287,439953,1028368,204598,1015648,256446,485499,123805,449043,312658,862897,357901,490534,551158,37996,44775,889747,582867,697452,438945,274826,961430,949552,175603,255764,347973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]