SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346183 LIMIT 1 [ RunTime:0.001169s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346183 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566644,995595,218022,978566,1010589,77038,786504,461589,1035484,656383,811097,680770,157467,175729,650765,115464,407376,831470,268599,125940,473638,648739,832325,771601,800011,685368,873442,234269,297415,814357,72653,840598,61785,237501,854306,337585,442524,584536,860860,878700,321354,455941,675834,922249,225228,889068,928249,441800,20091,483809,149612,562318,599174,833206,154645,439981,27883,915229,839630,205559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002262s ]