SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 915052 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 915052 [ RunTime:0.002911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894074,89333,939255,105068,194813,254360,930839,229843,382016,474651,618310,737524,960173,338047,296104,556275,770061,605256,591041,644513,311198,375995,770546,1013654,993570,531020,209047,1031088,1000098,968839,148981,97432,439175,1038591,451214,654281,275138,248396,1046225,40092,979517,646188,789097,262180,152455,892767,611937,781459,848354,348405,789590,203967,877324,694379,801010,919375,59283,940049,32140,201439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 915052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 915052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]