SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531117 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531117 [ RunTime:0.002397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36705,751409,962686,735815,985235,127684,357217,600839,507486,842503,809327,686073,115529,569432,356506,451480,220534,1025352,133861,199407,451557,620976,282032,779329,723188,3098,787644,882432,126613,665211,222685,663563,994871,976110,106774,544520,708826,306815,695620,620282,833620,780116,1015684,283130,775625,471838,976643,782172,413971,514227,602695,281515,181548,203142,11503,646672,795062,142736,999596,69364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]