SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031666 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031666 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138672,510068,799654,881274,120305,100248,621654,768613,943011,101576,544857,225223,629269,737441,574259,708154,102155,377566,589858,43492,954417,927773,103689,297756,506714,166310,613449,1011391,346050,223598,595944,453683,421933,517255,300784,986357,354860,199957,453551,1034285,46723,336784,143329,120505,207640,284481,212620,128004,836708,143267,548229,565333,500154,109615,913535,288597,437225,195469,355269,251822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031666 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031666 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]