SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101484 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101484 [ RunTime:0.005162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837467,817491,1020911,861236,790432,752012,846033,850949,776005,444846,665881,826506,985679,473111,240764,871048,790448,958642,563250,302995,815432,67595,525240,342848,381375,304869,786564,70609,524963,915039,703142,63009,865529,495810,606987,53452,431856,713805,581279,38743,160673,108763,713891,533885,62500,305393,813119,96822,775801,222144,80583,169792,304797,524738,364088,605848,679600,552386,1033663,1002179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]