SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420184 LIMIT 1 [ RunTime:0.000606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420184 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518904,262568,154379,411109,939787,737126,904065,734899,183460,768052,823380,284215,339219,270364,661621,1046679,477346,709902,759421,873102,376961,809186,964592,18736,193355,405151,632777,85354,38921,709750,374648,890633,896084,962897,756933,745949,362848,746354,595629,367389,875828,1011211,309805,445055,552503,180148,155281,1047228,421959,95324,178381,186705,855533,908876,105748,753717,15176,183412,79083,732408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]