SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429045 LIMIT 1 [ RunTime:0.000664s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429045 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858413,942470,82279,87593,871746,484164,493002,169541,638397,294039,177673,238140,235543,91534,466003,476999,159262,406991,141106,287004,882899,114975,579640,838543,908052,78305,135030,452873,150220,141277,290649,521206,649815,343275,302260,1012243,456673,351068,165066,959049,459267,879315,268697,638060,459120,958196,68972,924049,608748,699041,259109,61690,234894,878381,654925,855613,648783,735985,146578,117559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]