SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544192 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544192 [ RunTime:0.001120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801674,884341,400161,666678,784815,446274,135953,242951,707574,362094,871551,162937,8085,202363,27366,949524,688315,816540,692074,625649,542322,777850,170226,79576,100239,122399,851754,20216,809870,963604,371762,108444,381761,248291,605682,625768,443144,655891,10908,57249,39126,216980,639946,554040,347376,514480,891330,158153,977375,1026245,908595,793978,314263,662877,587381,914099,684957,892608,854973,357401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001351s ]