SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531028 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531028 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274390,766137,707317,212980,780351,196032,174345,894456,109629,285035,107192,404893,308997,774452,506763,1032172,280359,245457,317276,830558,626981,766532,791734,175298,185366,253208,432104,915955,973748,1043589,439603,58457,59591,505976,192663,345930,291935,467808,4005,95574,899584,720102,287733,232434,531479,883812,564455,274152,295684,952771,996518,324848,941412,6299,105889,726631,584538,522358,381361,196480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]