SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047786 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047786 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027882,268031,436979,788878,389423,787951,1011245,522731,920277,766796,627135,628895,1002666,653388,681956,958661,393465,822274,510862,1044953,285345,368278,479080,706766,40614,805693,768556,23219,542881,560762,266871,185665,448236,184277,174649,636974,640521,192700,81255,300659,886265,399680,600105,891526,989551,434502,403836,802260,272561,646996,811053,490973,527164,551502,45152,943504,1002671,679517,1041766,479834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001228s ]