SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019438 LIMIT 1 [ RunTime:0.001614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019438 [ RunTime:0.005207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789272,710534,298729,899775,543486,598128,517248,285241,577643,1032227,786572,923918,854638,201084,177630,120959,495669,174172,671484,934487,680024,36591,648386,161487,238872,790060,310169,592041,276597,933297,594040,1011941,131431,224498,429807,658689,963991,651634,41150,878683,591561,511821,848247,288711,675386,719639,667733,978367,704103,988741,341966,306934,592244,396280,224765,676246,864776,764860,1010465,509392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]