SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453991 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453991 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155532,716088,427790,944090,499887,760682,88083,372589,16948,987326,387458,330650,1000035,293962,897220,458133,569963,585594,184220,871527,134412,156548,196542,107378,437606,731347,280698,524262,726279,911011,401963,621382,48010,570587,929236,994095,914482,1038221,150993,4124,527125,1010354,814891,498772,694557,275670,366078,639865,652997,482902,257623,226189,265857,330606,167361,477985,140112,502547,997170,259179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]