SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378671 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378671 [ RunTime:0.002490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717667,129920,883867,351656,485183,609790,577428,608160,292049,768915,849976,144625,487372,1024849,712045,740587,382030,430942,983932,754785,706253,218486,496095,448341,151,832243,544557,1010045,461781,926963,642669,967383,914501,315450,90136,951844,528773,660998,751429,500058,862733,692337,82390,310842,815412,791444,1007508,325092,760183,306475,652668,506179,63494,215769,595425,527599,736015,561073,196579,128409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002383s ]