SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 845210 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 845210 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613904,1048193,204538,34812,108137,870977,713441,602867,526836,574010,1022357,80007,155009,743522,419650,583053,819974,92752,720922,468459,1034078,859309,516636,248407,452004,802797,501271,803288,416923,124079,437237,779732,324314,374788,60636,333505,374715,549445,996593,484784,982258,889131,575018,775050,285034,853897,804693,490170,636736,1046619,460304,219319,1025275,800778,205483,8778,447754,727018,897181,200417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 845210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 845210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]