SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805026 LIMIT 1 [ RunTime:0.001054s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805026 [ RunTime:0.003319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115234,280431,446976,266997,545222,668615,248617,703104,951404,18140,54262,144970,219508,59768,447862,247340,452179,291699,125290,519643,892646,739278,358608,426163,241465,312579,900922,511016,928796,676078,194742,1027714,842550,708111,514788,792274,416556,976355,657813,424583,523900,664625,699417,15486,84717,864645,120826,39228,742929,867588,7611,265767,885693,291690,947469,198815,73393,224483,1033853,296776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]