SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047842 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047842 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482196,97128,808183,102555,912096,1042028,882749,8819,105398,556953,563789,405016,416726,2005,637936,181514,116910,974780,195114,591847,922960,5925,6399,715448,527939,230477,1035745,241575,786657,530078,927879,821963,247708,133572,1035175,581074,1011814,528264,599431,894773,513185,527902,954019,275919,682097,30445,498109,828319,555142,896661,302644,407880,143029,462408,915862,353455,1006172,194932,475282,400009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]