SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030311 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030311 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905204,812635,693118,451661,580327,80998,593321,248581,1021708,396077,82801,34015,494028,571326,845231,7458,801203,435993,978273,613595,1001555,488293,405578,227889,804187,352716,777390,450359,511993,77159,327746,585863,701355,931735,712994,50278,626678,138305,553729,957364,921767,203469,723678,928345,791169,859120,194133,153277,415051,717436,299897,522514,843851,854105,3108,210705,792284,729042,308992,549026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.049360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001638s ]