SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034096 LIMIT 1 [ RunTime:0.001250s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034096 [ RunTime:0.003866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106512,444486,792894,318689,1006831,641194,957721,666829,468173,727822,803968,810064,920722,367195,278984,544162,414670,496061,133078,516306,268492,788958,397092,323298,675067,719207,766983,7981,206395,964674,50502,209349,730647,13061,616083,211347,880208,328274,432481,439897,208087,815428,476144,521520,573361,181403,141096,741407,441602,765138,700052,329102,527333,268342,482480,836403,358566,665769,363763,1022570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]